Comment on SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/sparentComments−datadeft3yI am not sure if this works on my end: sqlite> PRAGMA journal_mode = delete; delete sqlite> PRAGMA journal_mode = wal2; delete Does this mean wal2 is not available?−polyrand3ywal2 mode is not part of the main development branch of SQLite, you need to compile SQLite yourself from that branch. Same with BEGIN CONCURRENT [0][0]: https://www.sqlite.org/src/doc/begin-concurrent/doc/begin_co...−datadeft3yThank you!
Comments
I am not sure if this works on my end:
Does this mean wal2 is not available?wal2 mode is not part of the main development branch of SQLite, you need to compile SQLite yourself from that branch. Same with BEGIN CONCURRENT [0]
[0]: https://www.sqlite.org/src/doc/begin-concurrent/doc/begin_co...
Thank you!