[Buildbot-commits] [SPAM] Re: [Buildbot] #829: Buildbot 0.8.0rc2 waterfall is unusably slow

[Buildbot]

#829: Buildbot 0.8.0rc2 waterfall is unusably slow
---------------------+------------------------------------------------------
Reporter:  bdbaddog  |       Owner:       
    Type:  defect    |      Status:  new  
Priority:  critical  |   Milestone:  0.8.0
 Version:  0.8.0     |    Keywords:       
---------------------+------------------------------------------------------
Changes (by willw):

 * cc: lantictac@… (added)


Comment:

 We're seeing the same performance issues here. The unfiltered waterfall
 page is taking around 12 seconds to generate. Filtering by committer gets
 the time down to about 3 seconds. This is with 8 builders running on 14
 different windows slaves, although the master's running on Debian
 (squeeze/sid) with a dual core 3.20GHz CPU.

 And we cleared our build history when we upgraded to rc2 so fetching data
 from the DB should take no time at all - as there isn't much data to
 filter and fetch in the first place!

 The results for the command-line sqlite test:

 {{{
 /usr/bin/time -p sqlite3 state.sqlite 'select * from changes order by
 changeid' > /dev/null
 real 0.01
 user 0.01
 sys 0.00

 /usr/bin/time -p sqlite3 state.sqlite 'select * from changes' > /dev/null
 real 0.01
 user 0.01
 sys 0.00
 }}}

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