SQLite Forum

Importance of "exclusive" in speedtest
Login

Importance of "exclusive" in speedtest

(1) By Neha (agnhdb) on 2020-12-15 22:47:39 [source]

Hi, I am trying to performance test the SQLite using speedtest1 program and trying to understand the meaning and importance of a few configurations that speedtest exposed. In particular, I am looking to understand "exclusive" as enable. I can see that speedtest runs faster by enabling exclusive. Could you please help me understand this behavior? I am just running speedtest with exclusive and everything just defaults.

Thanks!

(2) By Keith Medcalf (kmedcalf) on 2020-12-16 00:38:46 in reply to 1 [link] [source]

The exclusive option flag sets the locking_mode to exclusive.

https://sqlite.org/pragma.html#pragma_locking_mode

Does this answer your question?