Add `traversal_ids` and `archived` columns to the `sbom_occurrences` table
Why are we doing this work
As we are trying to improve the performance of the group-level dependency list page, we are doing some schema denormalization to make it possible to remove join to the projects table for the group-level queries. In this issue, we are adding the namespaces.traversal_ids and projects.archived columns to the sbom_occurrences table to make it possible to remove that projects table join.
Implementation plan
-
database Add traversal_idsandarchivedcolumns to thesbom_occurrencestable.
Verification steps
- Verify that migration completed successfully
Edited by Brian Williams (Ex-GitLab)