I have a performance issue in regards to Software inventory (>1m request times). We have around 20k hosts, and I just updated to 4.10. During the page load, it does increase the load of the database a bit, but still isn't maxing out. Fleet instances don't really change. Horizontal deployment on GCP Kubernetes connecting to cloud managed MySQL. Pods are a bit beefy and don't increase load when the request is happening. Is this a known issue or something related to my deployment?

Hi Coleton, there are some things that are more resource hungry than others. We try to optimize things as much as possible though. Do you mind creating an issue with this data https://github.com/fleetdm/fleet/issues/new/choose so that we can track this and look into it?

@Coleton The software request does take a bit for larger deployments, but shouldn't be taking that long. For example, in our load test environment we have 88K software items and it takes 11s to load.

@Coleton from the second screenshot it appears as though you might be running

db-standard-4

? Temporarily can you bump up the CPU count on the Cloud MySQL instance? I suspect that is the bottleneck at the moment. If you see improvements from just vertically scaling, we might have a better idea of whats going on.