You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is your feature request related to a problem? Please describe.
Currently, the certifier query for all packages (for osv) and sources (for scorecard). After the packages are obtained, a neighbors query is called either search for certVuln or scorecard node respectively.
This is very inefficient and results in queries hitting issues specified in the issue #1848.
Describe the solution you'd like
Instead, a specific query should be created (that can be used by the certifiers) for just the packages or sources that need to be either checked or updated (based on a timestamp being set). All the filtering will be done by the database query which will be much more efficient. We may still face the parameter issue faced in issue #1848 so pagination will still be required.
Describe alternatives you've considered
Keep it as it is but as the scale of the DB grows, it will become inefficient.
The text was updated successfully, but these errors were encountered:
Is your feature request related to a problem? Please describe.
Currently, the certifier query for all
packages
(for osv) andsources
(for scorecard). After the packages are obtained, a neighbors query is called either search forcertVuln
orscorecard
node respectively.This is very inefficient and results in queries hitting issues specified in the issue #1848.
Describe the solution you'd like
Instead, a specific query should be created (that can be used by the certifiers) for just the packages or sources that need to be either checked or updated (based on a timestamp being set). All the filtering will be done by the database query which will be much more efficient. We may still face the parameter issue faced in issue #1848 so pagination will still be required.
Describe alternatives you've considered
Keep it as it is but as the scale of the DB grows, it will become inefficient.
The text was updated successfully, but these errors were encountered: