#automation
#future
#prompt-engineering
#future
#llm-ops
#optimization
PRAGMA journal_mode = WAL
. Improves performance for frequent writes. It allows concurrent reads and writes.PRAGMA synchronous = NORMAL
. Improves performance. We might lose a few transactions but won't corrupt the database.PRAGMA mmap_size = 128000000
. Set global memory map for processes to share dataPRAGMA journal_size_limit = 64000000
. Limit WAL file to prevent unlimited growthBEGIN IMMEDIATE
instead of BEGIN
. Prevents writes to the journal file until the transaction is complete. Improves concurrency.#ai-coding-tools
#future
#prompt-engineering