[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
bug#43850: cuirass: inconsistent SQL queries execution time.
From: |
Mathieu Othacehe |
Subject: |
bug#43850: cuirass: inconsistent SQL queries execution time. |
Date: |
Wed, 14 Oct 2020 18:53:20 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) |
Hello,
I pushed and deployed several patches that:
- update metrics in a single transaction
- register builds in a single transaction
- use a single write database worker, queuing queries and submitting
them by batches (in a single transaction).
- optimize some SQLite parameters (decrease WAL size, use more RAM
caching)
this should improve the situation, even if I still observe some
inconsistent execution duration.
I still have a few improvement ideas such as pre-allocating a large
database file to decrease fragmentation and running periodic vacuums.
Thanks,
Mathieu
- bug#43850: cuirass: inconsistent SQL queries execution time., Mathieu Othacehe, 2020/10/07
- bug#43850: cuirass: inconsistent SQL queries execution time.,
Mathieu Othacehe <=
- bug#43850: cuirass: inconsistent SQL queries execution time., Mathieu Othacehe, 2020/10/20
- bug#43850: cuirass: inconsistent SQL queries execution time., Mathieu Othacehe, 2020/10/22
- bug#43850: cuirass: inconsistent SQL queries execution time., Ludovic Courtès, 2020/10/26
- bug#43850: cuirass: inconsistent SQL queries execution time., Christopher Baines, 2020/10/27
- bug#43850: cuirass: inconsistent SQL queries execution time., Mathieu Othacehe, 2020/10/27
- bug#43850: cuirass: inconsistent SQL queries execution time., Mathieu Othacehe, 2020/10/27
- bug#43850: cuirass: inconsistent SQL queries execution time., Maxim Cournoyer, 2020/10/31