Created
June 1, 2023 14:04
-
-
Save fangzhou-xie/9ece135a4fdf0de7994cb2a8eb1dbc84 to your computer and use it in GitHub Desktop.
sqlite parameters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# optimization parameters | |
DBI::dbExecute(con, "PRAGMA journal_mode = wal;") | |
DBI::dbExecute(con, "PRAGMA synchronous = normal;") | |
DBI::dbExecute(con, "PRAGMA cache_size = -128000;") | |
DBI::dbExecute(con, "PRAGMA page_size = 4096;") | |
DBI::dbExecute(con, "PRAGMA locking_mode = EXCLUSIVE;") | |
DBI::dbExecute(con, "PRAGMA temp_store = MEMORY;") |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment