diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-05-25 11:08:20 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-05-25 11:08:20 +0100 |
| commit | 9265949cf669b9e861bc85a1f1c3954cf4e216cc (patch) | |
| tree | 89579191bda64514cbd4d5023bf33081a8b7c089 /examples/hello-subset.scm | |
| parent | 68a6912ce2e5d281bc7b45bf447b7695f5425388 (diff) | |
| download | cuirass-9265949cf669b9e861bc85a1f1c3954cf4e216cc.tar cuirass-9265949cf669b9e861bc85a1f1c3954cf4e216cc.tar.gz | |
cuirass: Perform some database "optimization" at startup.
Add a "optimize" step that occurs when starting up the main Curiass
process. Currently this does two things, but could be extended to do more.
The "PRAGMA optimize;" command prompts SQLite to ANALYZE tables where that
might help. The "PRAGMA wal_checkpoint(TRUNCATE);" command has SQLite process
any unprocessed changes from the WAL file, then truncate it to 0 bytes. I've
got no data to suggest this helps with performance, but I'm hoping that going
from a large WAL file to a small one occasionally might be useful.
* src/cuirass/database.scm (db-optimize): New procedure.
* bin/cuirass.in (main): Run it.
Diffstat (limited to 'examples/hello-subset.scm')
0 files changed, 0 insertions, 0 deletions