Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Some tweaks that I keep for my personal toy webservices:

    PRAGMA journal_mode = WAL;
    PRAGMA busy_timeout = 5000;
    PRAGMA synchronous = NORMAL;
    PRAGMA cache_size = 1000000000;
    PRAGMA foreign_keys = true;
    PRAGMA temp_store = memory;
And use BEGIN IMMEDIATE transactions.

https://kerkour.com/sqlite-for-servers



What is your opinion on cache_size vs mmap_size?


Sorry, no opinion, I just copied these from the article and it works fine enough for me.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: