While query rewrites have aided SQL efficiency considerably, an easy way to boost performance is to periodically run ANALYZE and perhaps even VACUUM. For SQLite, it would probably also be beneficial to checkpoint the write-ahead log at the end of every service iteration.
While query rewrites have aided SQL efficiency considerably, an easy way to boost performance is to periodically run `ANALYZE` and perhaps even `VACUUM`. For SQLite, it would probably also be beneficial to checkpoint the write-ahead log at the end of every service iteration.
jking
added this to the 0.8.0 milestone 5 years ago
While query rewrites have aided SQL efficiency considerably, an easy way to boost performance is to periodically run
ANALYZE
and perhaps evenVACUUM
. For SQLite, it would probably also be beneficial to checkpoint the write-ahead log at the end of every service iteration.