[Buildbot-commits] [Buildbot] #1936: optimize getOldestRequestTime
Buildbot
nobody at buildbot.net
Thu Sep 22 21:17:51 UTC 2011
#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
More information about the Commits
mailing list