Hacker News new | past | comments | ask | show | jobs | submit
Indeed: https://github.com/search?q=repo%3Aanacrolix%2Fpossum+pragma...
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."