[Buildbot] #3537: console_view is slow when the db is very big

[Buildbot trac]

#3537: console_view is slow when the db is very big
------------------------+--------------------
Reporter:  tardyp       |       Owner:
    Type:  enhancement  |      Status:  new
Priority:  critical     |   Milestone:  0.9.1
 Version:  master       |  Resolution:
Keywords:               |
------------------------+--------------------

Comment (by aelsabbahy):

 We're running into a similar problem with the buildbot main page. It is
 also degrading over time.

 {{{time curl
 'https://nine.buildbot.net/api/v2/builds?complete=true&limit=1&order=-buildid'}}}

 1.3 seconds for ~15k builds


 In our BB deployment we're seeing:

 ~3-5 seconds for ~80k builds

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