Add another index to speed up the jobstatus page
[?]
Nov 29, 2011, 5:48 PM
PT5XCF2NZMSKB3O6DNV5XNKOSXRUDTATTBMBP2FAUIREUM6X246ACDependencies
- [2]
C5W3WZ3Y* Index the Builds table on drvPath to prevent a full table scan - [3]
5L272QSCSpeed up the /jobset overview pages a lot - [4]
2I2ZX6JB* Make the "latest succeeded" query (used by the "latest" channel) - [5]
E2TOU3L6* More indices. - [6]
P5VJCT6Ufix wrong comment - [7]
6QRHXIM3* Speed up the jobset index page. Especially the query to get the - [*]
N22GPKYT* Put info about logs / build products in the DB.
Change contents
- replacement in src/sql/hydra.sql at line 535
create index IndexBuildsOnJobsetFinishedTimestamp on Builds(project, jobset, finished, timestamp);create index IndexBuildsOnJobsetFinishedTimestamp on Builds(project, jobset, finished, timestamp DESC); - edit in src/sql/hydra.sql at line 537
create index IndexBuildsOnJobSystemCurrent on Builds(project, jobset, job, system, isCurrent);