Project

General

Profile

Actions
Copy link

action #41054

closed

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

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

Status:
Resolved
Priority:
High
Assignee:
mkittler
Category:
Regressions/Crashes
Target version:
Done
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 open — 0 closed)

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

Actions
Actions
Copy link
 #1

Updated by coolo about 6 years ago

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

Updated by mkittler about 6 years ago

  • Assignee set to mkittler
Actions
Copy link
 #3

Updated by mkittler about 6 years ago

  • Status changed from New to In Progress
Actions
Copy link
 #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
Copy link
 #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
Copy link
 #6

Updated by szarate about 6 years ago

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

Updated by coolo about 6 years ago

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

Updated by coolo about 6 years ago

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

Updated by okurz over 3 years ago

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

Also available in: Atom PDF