[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: |
Tue, 20 Oct 2020 13:45:12 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) |
Hello,
> this should improve the situation, even if I still observe some
> inconsistent execution duration.
I tried to use the two following pragma:
--8<---------------cut here---------------start------------->8---
PRAGMA synchronous = OFF
PRAGMA mmap_size = 10737418240
--8<---------------cut here---------------end--------------->8---
hoping that mmaping the Cuirass database and disabling synchronisation
would help, but there were still inconsistent duration.
I have now copied the database to a tmpfs mounted directory to make sure
that those inconsistent duration are only caused by the I/O pressure on
berlin.
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, 2020/10/14
- bug#43850: cuirass: inconsistent SQL queries execution time.,
Mathieu Othacehe <=
- 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