Project

General

Profile

action #41054

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

Added by coolo almost 2 years ago. Updated over 1 year ago.

Status:
Resolved
Priority:
High
Assignee:
Category:
Concrete Bugs
Target version:
Start date:
2018-09-14
Due date:
% Done:

0%

Estimated time:
Difficulty:
easy
Duration:

Description

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

History

#1 Updated by coolo almost 2 years ago

  • Target version changed from Ready to Current Sprint

#2 Updated by mkittler almost 2 years ago

  • Assignee set to mkittler

#3 Updated by mkittler almost 2 years ago

  • Status changed from New to In Progress

#4 Updated by mkittler almost 2 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.

#5 Updated by mkittler almost 2 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.

#6 Updated by szarate almost 2 years ago

  • Target version changed from Current Sprint to Done

#7 Updated by coolo almost 2 years ago

  • Target version changed from Done to Current Sprint

#8 Updated by coolo over 1 year ago

  • Target version changed from Current Sprint to Done

Also available in: Atom PDF