Actions
action #94354
closedcoordination #80142: [saga][epic] Scale out: Redundant/load-balancing deployments of openQA, easy containers, containers on kubernetes
coordination #92854: [epic] limit overload of openQA webUI by heavy requests
Optimize /dashboard_build_results and /group_overview/* pages
Description
On the homepage and group_overview pages comment_data_for_jobs is called. It collects bugrefs and fetches all bugs, but in those views we don't even show this data.
Also, all columns of Comments are selected, while only two are needed.
I looked into this while working on #93925
I already did a fix, so even if this is not a high priority, it's already done, and an easy fix. So i took the liberty to create this ticket and a PR.
Runtime before:
/group_overview/1: 1.0-1.1s
/dashboard_build_results: 0.9-0.95s
Runtime after:
/group_overview/1: 0.8-0.85s
/dashboard_build_results: 0.75-0.77s
SQL statements which will be saved:
SELECT me.id, me.bugid, me.title, me.priority, me.assigned, me.assignee, me.open, me.status, me.resolution, me.existing, me.refreshed, me.t_created, me.t_updated FROM bugs me WHERE ( me.bugid = ? ): 'boo#1183454'
SELECT me.id, me.bugid, me.title, me.priority, me.assigned, me.assignee, me.open, me.status, me.resolution, me.existing, me.refreshed, me.t_created, me.t_updated FROM bugs me WHERE ( me.bugid = ? ): 'poo#92945'
SELECT me.id, me.bugid, me.title, me.priority, me.assigned, me.assignee, me.open, me.status, me.resolution, me.existing, me.refreshed, me.t_created, me.t_updated FROM bugs me WHERE ( me.bugid = ? ): 'poo#92401'
SELECT me.id, me.bugid, me.title, me.priority, me.assigned, me.assignee, me.open, me.status, me.resolution, me.existing, me.refreshed, me.t_created, me.t_updated FROM bugs me WHERE ( me.bugid = ? ): 'boo#1180358'
# and so on
for each build
Actions