#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
------------------------------------------------------------------------------
_______________________________________________
Buildbot-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/buildbot-commits
