Project

General

Profile

Actions

action #132161

open

Improve performance of openQA's workers table

Added by mkittler 10 months ago. Updated 10 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Feature requests
Target version:
Start date:
2023-06-29
Due date:
% Done:

0%

Estimated time:

Description

The workers table (e.g. https://openqa.opensuse.org/admin/workers) loads quite slowly. The table is rendered as HTML which is the most inefficient way to use DataTables. So supposedly we could already gain a notable speedup by simply returning the data as JSON which is a more efficient way to use DataTables.

Possibly the database query could also be made more efficient. The upfront count could be avoided (by simply using the array size of the main query). The extra queries/grepping to compute the number of free and broken workers could be avoided (by computing this in the main loop instead).

Actions #1

Updated by okurz 10 months ago

  • Target version set to future
Actions

Also available in: Atom PDF