Abnormally long loading times for software vulnerabilities page

[mason-buettner]

Update

This issue primarily addressed the loading times for the Vulnerabilities page, while the Software and Software versions endpoints are going to be addressed separately here: #34677

---

Fleet version: 4.72.0

Web browser and operating system: Chrome 139 on macOS 15.6

---

💥  Actual behavior

customer-numa reports that software overview via the web UI is taking an abnormally long time to load. This performance issue presents on their production environment, but not staging. The key difference between the two environments is the volume of enrolled hosts, which is higher on production.

🛠️ To fix

TBD

Product designer: _________________________

🧑‍💻  Steps to reproduce

1. Inventory software across a high number of hosts.
2. Observe slowdowns on software search/overview.
3. Compare against an environment with a lower number of hosts.

🕯️ More info (optional)

N/A

QA

Victor tested on loadtest with 15K online hosts.

Software -> Versions

No noticeable improvement. Follow up bug filed: #34677

Software -> Vulnerabilities

Some improvement, although not huge (~40%)
Before fix for vulnerabilities:

After fix for vulnerabilities:

[Sampfluger88]

Linked to Unthread ticket:

Performance issue with SW search/overview on production instance #7990

[mostlikelee]

Hi @mason-buettner can you help with more information here? How long is the page load or API time? How many hosts? How many software titles? Is the performance issue on initial page load, or only when performing certain filters/sorts?

[jmwatts]

@mason-buettner Can you also provide the types of hosts enrolled and the number of teams in the environment please?