Repository navigation
Commit 9bf8c50
perf(server): migrate-dev-db legacy guard uses the V2 created-threads index
Without a hint SQLite answers the correlated NOT EXISTS with a per-thread
stream index scan. On 3000 imported threads with 30000 events that took
150-270ms here and 20.7s in review; with the partial index the importer
already names, it takes about 1.5ms. The index ships in the same migration
as the V2 tables the guard checks for.
Co-Authored-By: Claude Opus 5.5 <[email protected]>1 parent 4324451 commit 9bf8c50
1 file changed
Lines changed: 4 additions & 2 deletions
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
251 | 251 | | |
252 | 252 | | |
253 | 253 | | |
254 | | - | |
| 254 | + | |
| 255 | + | |
255 | 256 | | |
256 | 257 | | |
257 | 258 | | |
258 | 259 | | |
259 | | - | |
| 260 | + | |
| 261 | + | |
260 | 262 | | |
261 | 263 | | |
262 | 264 | | |
| |||
0 commit comments