[Buildbot-commits] [Buildbot] #1936: optimize getOldestRequestTime

[Buildbot]

#1936: optimize getOldestRequestTime
----------------------------------+--------------------
Reporter:  dustin                 |       Owner:
    Type:  enhancement            |      Status:  new
Priority:  major                  |   Milestone:  0.8.6
 Version:  0.8.3p1                |  Resolution:
Keywords:  database, performance  |
----------------------------------+--------------------

Comment (by aivarsk):

 Can you provide a link to Catlee's code?

 This kills performance of our buildmaster. We have 35 builders and each
 getOldestRequestTime SELECT takes 0.01-0.07 seconds (buildrequests has
 125,400 records and buildsets has 14,461 records). 10 builders have about
 650 buildrequests each day (nightly build for 600 "projects") and others
 about 50 buildrequests per day.

 Tables had 1,344,969 and 165,365 records before and queries often showed
 up in logfiles ("Long query..." with 2 and more seconds). Not sure why
 tables were not cleaned up.

-- 
Ticket URL: <http://trac.buildbot.net/ticket/1936#comment:3>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation