lsm / HyperNeo / 32518931656

80%

push

github

perf(daemon): persist session context roomId/spaceId/taskId as generated columns (#2649)

* perf(daemon): persist session context roomId/spaceId/taskId as generated columns (#1155)

Adds room_id/space_id/task_id VIRTUAL generated columns to sessions
(migration 199, guarded by json_valid so malformed contexts read as
NULL), rewrites the hot json_extract(session_context) filters onto the
plain columns (sessions.list predicate, session repo lookups, usage
totals, space agent tools, task worker resolution), replaces the
provenance expression index with a space_id-keyed form, and adds a
partial idx_sessions_room_id. The reactive layer reads scope and taskId
from the columns instead of JSON.parsing session_context per write, and
message-search eligibility reads room_id instead of parsing context per
save. The session_counters triggers/backfill keep the json_extract
predicate since migration 198 runs before 199 on upgrade-path DBs.

* fix(daemon): drop prohibited cleanup comments in migration-200 test

44656 of 60045 branches covered (74.37%)

Branch coverage included in aggregate %.

24 of 25 new or added lines in 8 files covered. (96.0%)

60658 of 72422 relevant lines covered (83.76%)

3974.95 hits per line