#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
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Buildbot-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/buildbot-commits
