Change Journal Mode in SQLite Database

[markmckinnon]

Can the journal mode that the current SQLite database uses (DELETE which is default) be change to WAL journaling. This will increase the performance in entering information into the database dramatically. In one of the modules I ran with the default journaling mode, the module ran in 1451 seconds. When I ran the same module in WAL mode it ran in 40 seconds which is 36 times faster. When the SQLite database is created all that would need to be run is the following statement "PRAGMA journal_mode=wal;".

[markmckinnon]

Moving to Sleuthkit for this change.

[1dashen]

Whoops, looks like a little semicolon snuck in at the end of the statement. Hello from 2022!