Cấu Hình SQLite Production PRAGMA

-- SQLite Production PRAGMA Configuration
-- Generated by Locionic SQLite Configurator (https://locionic.com/vi/tools/sqlite-configurator)

-- 1. Storage page size (4096 bytes - MUST be set before creating database header/tables)
PRAGMA page_size = 4096;

-- 2. Enable Write-Ahead Logging for non-blocking concurrent readers
PRAGMA journal_mode = WAL;

-- 3. Synchronous safety level (NORMAL is crash-safe with WAL; FULL fsyncs every commit)
PRAGMA synchronous = NORMAL;

-- 4. Milliseconds to wait before returning SQLITE_BUSY when database is locked
PRAGMA busy_timeout = 5000;

-- 5. In-memory page cache size (64 MB RAM)
PRAGMA cache_size = -65536;

-- 6. Memory-mapped I/O size (256 MB)
PRAGMA mmap_size = 268435456;

-- 7. Temporary table and index storage (MEMORY)
PRAGMA temp_store = MEMORY;

-- 8. WAL file auto-checkpoint threshold (1000 pages)
PRAGMA wal_autocheckpoint = 1000;

-- 9. Enforce relational foreign key constraints
PRAGMA foreign_keys = ON;