Here are some often forgotten performance settings:
pragma journal_mode = WAL;
pragma synchronous = normal;
pragma temp_store = memory;
pragma mmap_size = 30000000000;
pragma page_size = 32768;
pragma cache_size = -1048576;
"Rule 2. Measure."