action #41054

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

Added by coolo over 1 year ago. Updated over 1 year ago.

Status:ResolvedStart date:14/09/2018
Priority:HighDue date:
Assignee:mkittler% Done:

0%

Category:Concrete Bugs
Target version:Done
Difficulty:easy
Duration:

Description

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

History

#1 Updated by coolo over 1 year ago

  • Target version changed from Ready to Current Sprint

#2 Updated by mkittler over 1 year ago

  • Assignee set to mkittler

#3 Updated by mkittler over 1 year ago

  • Status changed from New to In Progress

#4 Updated by mkittler over 1 year 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 over 1 year 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 over 1 year ago

  • Target version changed from Current Sprint to Done

#7 Updated by coolo over 1 year 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