[sqlite] Database occasionally very slow for trivial query

2018-09-10 Thread Joshua Watt
IF NOT EXISTS BB_URI_HEADREVS(key TEXT PRIMARY KEY NOT NULL, value TEXT); COMMIT; BEGIN TRANSACTION; SELECT COUNT(key) FROM BB_URI_HEADREVS; COMMIT; BEGIN TRANSACTION; DELETE FROM BB_URI_HEADREVS; COMMIT; Thanks all for your time, -- Joshua Watt ___

[sqlite] Strange behavior with wal_checkpoint PRAGMA

2018-02-14 Thread Joshua Watt
believe this is because walCheckpoint() triggers a call to walRestartHdr() if the mode is SQLITE_CHEKPOINT_TRUNCATE. Once walCheckpoint() returns, sqlite3WalCheckpoint() attempts to extract the values from the already restarted wal header. Has anyone else expir

Re: [sqlite] Strange behavior with wal_checkpoint PRAGMA

2018-02-20 Thread Joshua Watt
On Wed, 2018-02-14 at 08:13 -0600, Joshua Watt wrote: > Hello, > > I observed the following behavior when using the wal_checkpoint > PRAGMA > in TRUNCATE mode: > > SQLite version 3.22.0 2018-01-22 18:45:57 > Enter ".help" for usage hints. > Connected to