[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:  undecided  |     Status:  new
Priority:  major      |  Milestone:  0.9.0
 Version:  master     |   Keywords:
----------------------+-------------------
 console view does some big queries, with limit=xx, order=timestamp, but
 the queries are not optimized with limits, and the

 db2data takes a lot of time, before dropping most of the data

 We should at least optimize the query made by console view in data api.

 Probably, we should optimize all limit=xx, order=timestamp

 consoleview wants
 buildsets
 buildrequests
 builds
 and changes

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