Bug #35869
Host index page is slow
Status:
New
Priority:
Normal
Assignee:
-
Category:
Inventory
Target version:
-
Description
This is probably due to #35287 where additional columns are rendered. This likely leads to additional SQL queries.
I don't have a reference prior to the upgrade, but on my (production) machine with Foreman 3.5.0-rc2 it takes about 800ms to render (and send) the host index page HTML. Then it still needs to render on my browser etc. That feels way slower than it was before.
Looking in production.log I see a lot of allocations, which often is because of many SQL queries. It's likely that the reported data facets are retrieved one by one instead of in a single batch.
Related issues
History
#1
Updated by Ewoud Kohl van Wijngaarden 6 months ago
- Related to Feature #35287: Create column selector on host index page added
#2
Updated by Ewoud Kohl van Wijngaarden 6 months ago
- Found in Releases 3.5.0 added
#3
Updated by Ewoud Kohl van Wijngaarden 6 months ago
- Target version set to 3.5.1
- File 20221214_15h32m09s_grim.png 20221214_15h32m09s_grim.png added
It takes about 800 ms to render, but 4 to 5 seconds to load the full page on my browser.
#4
Updated by Ewoud Kohl van Wijngaarden 6 months ago
- Target version changed from 3.5.1 to 3.5.2
#5
Updated by Eric Helms 3 months ago
- Target version deleted (
3.5.2)