Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Switch to locking_mode EXCLUSIVE in libSQL server? #1630

Open
penberg opened this issue Aug 3, 2024 · 2 comments
Open

Switch to locking_mode EXCLUSIVE in libSQL server? #1630

penberg opened this issue Aug 3, 2024 · 2 comments
Labels
enhancement New feature or request help wanted Extra attention is needed question Further information is requested

Comments

@penberg
Copy link
Collaborator

penberg commented Aug 3, 2024

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.
@penberg penberg added enhancement New feature or request help wanted Extra attention is needed question Further information is requested labels Aug 3, 2024
@haaawk
Copy link
Contributor

haaawk commented Aug 4, 2024

FYI @MarinPostma

@haaawk
Copy link
Contributor

haaawk commented Aug 4, 2024

Also for embedded replicas (CC @LucioFranco )

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request help wanted Extra attention is needed question Further information is requested
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@penberg @haaawk