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
Commit 600751b
Browse filesBrowse the repository at this point in the historyBrowse files
perf(server): the shell read no longer sorts every run of every thread
The thread-shell list finds each thread's last executed run with a correlated
subquery ordered by completion time. No index carried that order, so SQLite
sorted the thread's whole run history for every thread in the list. On a
200-thread fixture with one million runs the shell query took 214 ms; with the
index it takes 2 ms and returns the same rows.
Migration 83 adds a partial index on the runs table in the order that lookup
reads, with the lookup's own predicate, so the shell query walks the index
instead of sorting. The lookup keeps its semantics: same runs, same order.
Refs #23000
Refs #9661
Co-Authored-By: Claude Code <[email protected]>
0 commit comments