Switch to locking_mode EXCLUSIVE in libSQL server?

tursodatabase / libsql

libSQL is a fork of SQLite that is both Open Source, and Open Contributions.

https://turso.tech/libsql

MIT License

11.24k stars 286 forks source link

Switch to locking_mode EXCLUSIVE in libSQL server? #1630

Open penberg opened 3 months ago

penberg commented 3 months ago

SQLite acquires a POSIX advisory lock by default for every read transaction. Let's consider switching to PRAGMA locking_mode=EXCLUSIVE to make SQLite acquire the POSIX advisory lock when a database file is opened, which improves read performance.

haaawk commented 3 months ago

FYI @MarinPostma

haaawk commented 3 months ago

Also for embedded replicas (CC @LucioFranco )