Large timelines are written with the overview index loaded in bulk (#199)
- github
- github/openchronology/timeline-app
- commit
- main
- github/athanclark
sqlite-rational's rational_index gains bulk loading (athanclark/sqlite-rational#1): rows appended to an empty index are linked once by a build, which writes a balanced tree bottom-up instead of walking and rebalancing it for every row. save() appends the buckets in ranges of 5000 times, each a statement well within the instruction budget, and builds once. och-convert writes 200,000 moments in about 9 s, within its 20 s CPU limit, where it stopped near 45,000; 10,000 take under a second instead of 4. Co-Authored-By: Claude Opus 5.5 Claude-Session: https://claude.ai/code/session_011fFY8eruEi1xAkkMBni13B https://github.com/openchronology/timeline-app/commit/ae3bbcf10284f103b66520bccd2c6af8a60bf2f2
Related
Open Large timelines are written with the overview index loaded in bulk (#199) in the timeline