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.

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

Heavy I/O with sqlite on Windows #817

Closed
frankTheTank72 opened this issue May 8, 2024 · 2 comments
Closed

Heavy I/O with sqlite on Windows #817

frankTheTank72 opened this issue May 8, 2024 · 2 comments
Assignees

Comments

@frankTheTank72
Copy link
Member

frankTheTank72 commented May 8, 2024

When I use sqlite on windows PC my I/O starts to go up to 100% and the sync rate is very slow.
Seems the sqlite is by default in FULL synchronous mode.

I should be able to set PRAGMA synchronous = OFF as parameter for the session.

Please add this paramter to the config in the node. (like WAL)

Hint
On Ubuntu it seeems to work fine

@frankTheTank72
Copy link
Member Author

Maybe also add PRAGMA cache_size -2000 parameter to define the cache

@ohager
Copy link
Member

ohager commented Jun 22, 2024

this should be "solved" using #819

@ohager ohager closed this as completed in 57431eb Jun 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants