You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
#404b Disable FTS5 triggers during bulk indexing #411
Three FTS5 triggers fire on every INSERT and DELETE to symbols table. During bulk indexing, this causes 3x write amplification (each symbol INSERT triggers an FTS5 index update).
DROP TRIGGER for the 3 FTS5 triggers at the start of bulk index
After indexing completes, rebuild FTS5 index with: INSERT INTO symbols_fts(rowid, name, signature) SELECT id, name, signature FROM symbols WHERE project_id=?
Recreate triggers after rebuild
Expected Impact
2-3x faster DB writes during indexing. Combined with #404 and #405, targets the write bottleneck directly.
Note
This is a companion to #404/40405. Must be done together to avoid inconsistency.
Activity
perf: Phase 1 + Search + Indexing — 1.8x cold index, 52x incremental,…
perf: parallelize extract and embed computation with Rayon (#411) (#422)
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)