[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Cuirass] Missing database indexes?

From: swedebugia
Subject: Re: [Cuirass] Missing database indexes?
Date: Mon, 19 Nov 2018 10:47:17 +0100


On 2018-11-10 18:33, Ludovic Courtès wrote:


--8<---------------cut here---------------start------------->8---
sqlite> CREATE INDEX Builds_index_evaluation ON Builds(evaluation);


Anything else we should do?

I woke up today with an idea. :)

Now on berlin it seems that all jobset are in one enormous table, correct?

How about creating a database/sqlite file for every specification and a table for every jobset? This would also solve the problem with overrunning id. (there will never be more ids than jobs in a single jobset in a table)

This means cuirass only work on one database per specification (now there are 5 specs on berlin)

Every jobset having its own table/file will lower the total number of rows, thus lower the computing cost of a table scan.


reply via email to

[Prev in Thread] Current Thread [Next in Thread]