Skip to content
Snippets Groups Projects

Bulk insert CVS vulnerability scanners

Merged Bulk insert CVS vulnerability scanners
otovar/bulk-insert-scanners-for-cvs-global-jobs into master
Merged Oscar Tovar requested to merge otovar/bulk-insert-scanners-for-cvs-global-jobs into master
  1. Jul 19, 2024
    • Oscar Tovar's avatar
      Bulk insert CVS vulnerability scanners · 067d8440
      Oscar Tovar authored 
      This improves the efficiency of scans by removing an N+1 query issue
that was adopted in the transition to global type scans (scans that
cover many projects at once). Previously, we tried to upsert scanners N
times (N being the number of projects in a scan), and as a result put a
lot of unnecessary pressure on the database. This should reduce the WAL
in theory, and overall improve the performance of the scanner.

Changelog: performance
      Verified
      067d8440