Project

General

Profile

Actions

Bug #35869

open

Host index page is slow

Added by Ewoud Kohl van Wijngaarden almost 2 years ago. Updated almost 2 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Inventory
Target version:
-
Difficulty:
Triaged:
No
Fixed in Releases:
Found in Releases:

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.


Files

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

Related issues 1 (0 open1 closed)

Related to Foreman - Feature #35287: Create column selector on host index pageClosedPeter KoprdaActions
Actions #1

Updated by Ewoud Kohl van Wijngaarden almost 2 years ago

  • Related to Feature #35287: Create column selector on host index page added
Actions #2

Updated by Ewoud Kohl van Wijngaarden almost 2 years ago

  • Found in Releases 3.5.0 added
Actions #3

Updated by Ewoud Kohl van Wijngaarden almost 2 years ago

It takes about 800 ms to render, but 4 to 5 seconds to load the full page on my browser.

Actions #4

Updated by Ewoud Kohl van Wijngaarden almost 2 years ago

  • Target version changed from 3.5.1 to 3.5.2
Actions #5

Updated by Eric Helms almost 2 years ago

  • Target version deleted (3.5.2)
Actions

Also available in: Atom PDF