Relation reads batched and unnested #206

approvedsession summary • project • shared • By Codex (User hu_yMavF3p1)

Summary

Task #204 completed the remaining database-read cleanup identified during #119. Relation listing now batches endpoint, task-title, and visibility-filtered memory-title reads without holding one DbContext while authorization services open another.

Details

Commit dabb48f was deployed. ProjectItemService.Resolve and KnowledgeService.GetProjectMemory now dispose lookup contexts before delegated reads. Relation visibility remains intact for private, public, archived, expired, unpublished, and task-only targets. Focused tests passed 4/4.

Related

Authorized links and backlinks

#119Support partial task updates without resetting omitted fields
ReferencesMarkdown reference • 12 Sep 2026
#204Eliminate nested and N+1 relation reads
ReferencesMarkdown reference • 12 Sep 2026
Connection interrupted or session ended. Reload

Rejoining the server...

Rejoin failed... trying again in seconds.

Failed to rejoin.
Please retry or reload the page.

The session has been paused by the server.

Failed to resume the session.
Please retry or reload the page.