Project

General

Profile

Actions

action #41054

closed

/tests is superslow if there are a lot of scheduled jobs

Added by coolo about 6 years ago. Updated almost 6 years ago.

Status:
Resolved
Priority:
High
Assignee:
Category:
Regressions/Crashes
Target version:
Start date:
2018-09-14
Due date:
% Done:

0%

Estimated time:

Description

scheduled_jobs queries $job->comments->count which means 3000 SQL queries for 3000 jobs


Related issues 1 (1 open0 closed)

Related to openQA Project - action #97190: Limit size of initial requests everywhere, e.g. /, /tests, etc., over webUI and APINew2022-05-30

Actions
Actions #1

Updated by coolo about 6 years ago

  • Target version changed from Ready to Current Sprint
Actions #2

Updated by mkittler about 6 years ago

  • Assignee set to mkittler
Actions #3

Updated by mkittler about 6 years ago

  • Status changed from New to In Progress
Actions #4

Updated by mkittler about 6 years ago

  • Status changed from In Progress to Feedback

Seems to work on OSD. Let's see how well it performs if lots of jobs are scheduled.

Actions #5

Updated by mkittler about 6 years ago

  • Status changed from Feedback to Resolved

I have just checked out OSD with currently 1158 scheduled jobs (941 blocked by other jobs) and it took only 2.9 seconds to load.

Actions #6

Updated by szarate about 6 years ago

  • Target version changed from Current Sprint to Done
Actions #7

Updated by coolo about 6 years ago

  • Target version changed from Done to Current Sprint
Actions #8

Updated by coolo almost 6 years ago

  • Target version changed from Current Sprint to Done
Actions #9

Updated by okurz about 3 years ago

  • Related to action #97190: Limit size of initial requests everywhere, e.g. /, /tests, etc., over webUI and API added
Actions

Also available in: Atom PDF