Search notes:

SQLite performance

Apparently, the following pragmas can be used if a database crash and loss of data can be managed:

pragma synchronous=off;
pragma cache_size=4000000;
pragma journal_mode=memory;
begin transaction;
…
commit;

Additionally, on Linux, the hdparm settings might be tuned.

See also