[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Cuirass news
From: |
Danny Milosavljevic |
Subject: |
Re: Cuirass news |
Date: |
Tue, 13 Feb 2018 10:12:36 +0100 |
Hi Ludo,
On Sat, 10 Feb 2018 12:18:56 +0100
address@hidden (Ludovic Courtès) wrote:
> Thinking about it, it wouldn’t matter that HTTP requests are processed
> sequentially if database queries run really fast. I’m not sure if we
> can achieve it. WDYT?
That depends on how fast. But it should be possible to optimize the actual
query (using indices, lookups are O(log N)). Also, if it's the same
query as before, it usually will be really fast as most of the pointers
are still where they were before.
Sqlite3 already automatically created indices for all the primary keys.
There's also https://www.sqlite.org/pragma.html#pragma_optimize if we need it.
We can always try it with serialized database access and use a connection
pool should it get too slow later.
- Re: Cuirass news, Ludovic Courtès, 2018/02/08
- Re: Cuirass news, Danny Milosavljevic, 2018/02/08
- Re: Cuirass news, Ludovic Courtès, 2018/02/08
- Re: Cuirass news, Danny Milosavljevic, 2018/02/08
- Re: Cuirass news, Gábor Boskovits, 2018/02/09
- Re: Cuirass news, Ludovic Courtès, 2018/02/09
- Re: Cuirass news, Danny Milosavljevic, 2018/02/09
- Re: Cuirass news, Ludovic Courtès, 2018/02/09
- Re: Cuirass news, Danny Milosavljevic, 2018/02/09
- Re: Cuirass news, Ludovic Courtès, 2018/02/10
- Re: Cuirass news,
Danny Milosavljevic <=
- Re: Cuirass news, Ludovic Courtès, 2018/02/14
- Re: Cuirass news, Ludovic Courtès, 2018/02/14
- Re: Cuirass news, Danny Milosavljevic, 2018/02/19
- [PATCH] database: Simplify 'db-get-builds'., Danny Milosavljevic, 2018/02/19
- [PATCH] database: db-get-builds: Inline output selection., Danny Milosavljevic, 2018/02/19
- Re: Cuirass news, Danny Milosavljevic, 2018/02/19
- Re: Cuirass news, Ludovic Courtès, 2018/02/14