Database maintenance #169

New issue

Closed

opened 2019-03-09 07:50:48 -05:00 by jking · 0 comments

jking commented

2019-03-09 07:50:48 -05:00

Owner

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.