Huge slowness when filtering SBOMs by name field #2105
Description
Filtering SBOMs by the name field (via the /sboms UI or via api/v2/sbom search) is extremely slow. Even exact full name matches take several minutes to load. This significantly impacts workflows that rely on resolving SBOMs by container image reference and makes the UI very slow, leading to a not good user experience.
In our deployment, we have 3,352,033 SBOMs, which reflects the scale at which this issue is occurring. At this scale, filtering by name becomes effectively unusable.
Example query:
https://atlas/api/v2/sbom?limit=10&offset=0&q=name~86f98bfffcff70e627d07bb22db273b04107d54619fc1c8a3555e01f387c48c7
This issue was created in order to, in case this is important to address, explore what potential solutions or improvements could be considered.