Attention Required! | Cloudflare
kerkour.com

TL;DR?

PRAGMA journal_mode = WAL;
PRAGMA busy_timeout = 5000;
PRAGMA synchronous = NORMAL;
PRAGMA cache_size = 1000000000;
PRAGMA foreign_keys = true;
PRAGMA temp_store = memory ;

  • 0x0@programming.devOP
    41·
    5 months ago

    Did you read the article?

    There’s more to SQLite than the embedded world and not everyone requires ClickHouse’s performance.

    • earmuff@lemmy.dbzer0.com
      11·
      5 months ago

      I actually did. There is still no reason to be wasteful with ressources. Why should I need to use a 4 core machine, when I could just use a single core machine?

      Only because „it works“, does not make it a valid reason to use it.

      • 0x0@programming.devOP
        21·
        5 months ago

        Why should I need to use a 4 core machine

        Just 'cos the article writer used one doesn’t mean you have to and i doubt “multiple CPUs” is a requirement for SQLite.