[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 |
Hi
On 2018-11-10 18:33, Ludovic Courtès wrote:
snip
--8<---------------cut here---------------start------------->8---
sqlite> CREATE INDEX Builds_index_evaluation ON Builds(evaluation);
snip
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.
--
Cheers
Swedebugia
- Re: [Cuirass] Missing database indexes?, (continued)
- Re: [Cuirass] Missing database indexes?, Clément Lassieur, 2018/11/13
- Re: [Cuirass] Missing database indexes?, Björn Höfling, 2018/11/16
- Re: [Cuirass] Missing database indexes?, Danny Milosavljevic, 2018/11/12
- Re: [Cuirass] Missing database indexes?, Danny Milosavljevic, 2018/11/12
- Re: [Cuirass] Missing database indexes?, Ludovic Courtès, 2018/11/14
- Re: [Cuirass] Missing database indexes?, Danny Milosavljevic, 2018/11/19
Re: [Cuirass] Missing database indexes?,
swedebugia <=