Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Improve csaf ingestion by caching existing purl statuses #1110

Open
dejanb opened this issue Dec 18, 2024 · 0 comments
Open

Improve csaf ingestion by caching existing purl statuses #1110

dejanb opened this issue Dec 18, 2024 · 0 comments

Comments

@dejanb
Copy link
Contributor

dejanb commented Dec 18, 2024

Currently we have a query in the loop while ingesting csaf documents

let package_status = purl_status::Entity::find()

This query will check if the status already exists before preparing the new one for ingestion. This can be expensive for documents with large number of statuses. The better approach would be to get all statuses based on advisory and vulnerability once before the loop and the check if purl/status combo already exists in the cache.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant