[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:       
---------------------+------------------------------------------------------

Comment(by dustin):

 Hmm, so the hypothesis that we must fetch all of the rows into memory
 first was false: it got to "starting 4" quite quickly.

 However, it takes ~2.5s to fetch each row, which seems like a lot.  The
 query is
 {{{
 SELECT changeid FROM changes ORDER BY changeid DESC
 }}}
 which is sorting on the primary key for that table, which in sqlite makes
 it an alias for the rowid.  Sqlite rows are stored in rowid order, so this
 should be the simplest possible query.

 How long does a:
 {{{
 sqlite3 state.sqlite  'select * from changes' > /dev/null
 }}}
 take?  How about
 {{{
 sqlite3 state.sqlite  'select * from changes order by changeid' >
 /dev/null
 }}}

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