Repository navigation
#406 SQLite PRAGMA tuning for throughput #408
Description
Problem
SQLite is opened with only journal_mode=WAL; foreign_keys=ON. Missing key throughput PRAGMAs.
Location
src/index/mod.rs:35-36 and src/engine/db_writer.rs:184-185
Solution
Add to open_global_index():
PRAGMA synchronous = NORMAL;
PRAGMA cache_size = -64000;
PRAGMA mmap_size = 268435456;
PRAGMA temp_store = MEMORY;Expected Impact
1.2-1.5x overall. Trivial change, zero risk.
Activity
perf: search optimization — 40x faster brain_search (#407 #408)
ajianaz commentedon Jul 28, 2026
Closed by #421 — N+1 get_symbol_by_id replaced with single WHERE id IN (...) query via batch_get_symbols().
perf: Phase 1 + Search + Indexing — 1.8x cold index, 52x incremental,…
chore: v0.9.0 release prep (#423)
chore: sync v0.9.0 release prep to develop (#424)
chore: sync v0.9.0 release prep to develop (#424) (#425)
release: v0.10.0 (#442)
release: v0.11.1 → main (#450)