Page MenuHomePhabricator

JobQueueGroup::getQueuesWithJobs used one query per type
Closed, ResolvedPublic

Description

Looking at the log gives many queries against the job table to determine, if some jobs exist there. The calls are out of JobQueueGroup::getQueuesWithJobs or JobQueueGroup::getDefaultQueuesWithJobs to JobQueue::isEmpty

Maybe this can be optimized by using a DISTINCT query? That sounds faster, than, by default, 9 queries.


Version: 1.21.x
Severity: normal

Details

Reference
bz45072

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 1:33 AM
bzimport set Reference to bz45072.
bzimport added a subscriber: Unknown Object (MLST).

Change 71966 had a related patch set uploaded by Aaron Schulz:
jobqueue: improved performance of JobQueueGroup::getQueuesWithJobs()

https://gerrit.wikimedia.org/r/71966

Change 71966 merged by jenkins-bot:
jobqueue: improved performance of JobQueueGroup::getQueuesWithJobs()

https://gerrit.wikimedia.org/r/71966