Speed up the /jobset overview pages a lot
[?]
Nov 29, 2011, 5:09 PM
5L272QSCJRKQ33QFPYACFFAYREBPK2FMS7IKNQGKN2CHKOHXHZOACDependencies
- [2]
TFVGX4JSAdd an index to speed up the /project/<name> pages - [*]
N22GPKYT* Put info about logs / build products in the DB. - [*]
P5VJCT6Ufix wrong comment - [*]
6QRHXIM3* Speed up the jobset index page. Especially the query to get the - [*]
2I2ZX6JB* Make the "latest succeeded" query (used by the "latest" channel)
Change contents
- edit in src/sql/hydra.sql at line 528
create index IndexBuildsOnJobIsCurrent on Builds(project, jobset, job, isCurrent); - edit in src/sql/hydra.sql at line 535[6.3040][7.704]
create index IndexBuildsOnJobsetFinishedTimestamp on Builds(project, jobset, finished, timestamp);