On 10 September 2018 at 22:28, Joshua Watt <jpewhac...@gmail.com> wrote:
> BEGIN TRANSACTION; DELETE FROM BB_URI_HEADREVS; COMMIT; > Normally, this query takes no more than 1-3 seconds to complete, > however, on rare occasion this will take an order of magnitude more > (20-30 seconds). > > pragma synchronous = normal; pragma journal_mode = WAL; pragma > wal_autocheckpoint = 100; > I use the small wal_autocheckpoint because the database is read- > mostly, and we would rather have fast readers at the expense of > occasional slow writes. > I don't have much experience with WAL mode, but these two statements jump out at me. Is it simply the auto-checkpoint which ends up taking a long time when the machine is already under heavy i/o load? -Rowan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users