Re:Getting the Most Out of Sqlite3 with Python
by justinclift on Monday October 23, 2017 @03:56PM
(#15536428)
> ... don't know where it could be used practically.
Maybe with read only databases?
Re:Getting the Most Out of Sqlite3 with Python
by mythrwy on Tuesday October 24, 2017 @03:12PM
(#15544360)
Would you get a speed increase in reads? I thought async and wal speedup would just be for writes (no good for read only database). Maybe I'm misinformed. Have to play with it and see.
Re:Getting the Most Out of Sqlite3 with Python
by justinclift on Friday October 27, 2017 @05:19PM
(#15572314)
Hmmm, I'm not sure either. If you got around to testing it, it'd be interesting to hear about. :)
That being said 'journal_mode=wal' is a bit faster than normal async but nowhere even close to the speed of disabling async completely.