Project

General

Profile

Bug #35869

Host index page is slow

Added by Ewoud Kohl van Wijngaarden 6 months ago. Updated 3 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Inventory
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

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.

20221214_15h32m09s_grim.png View 20221214_15h32m09s_grim.png 168 KB Ewoud Kohl van Wijngaarden, 12/14/2022 03:36 PM
20221214 15h32m09s grim

Related issues

Related to Foreman - Feature #35287: Create column selector on host index pageClosed

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

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)

Also available in: Atom PDF