Actions
action #132161
openImprove performance of openQA's workers table
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).
Updated by tinita over 1 year ago
Also: prefetching properties
in https://github.com/os-autoinst/openQA/blob/master/lib/OpenQA/WebAPI/Controller/Admin/Workers.pm#L41
Actions