perf(search): keyset pagination (browse path) #36

Merged

cesnimda merged 1 commits from feat/keyset-pagination into develop 2026-07-04 16:01:40 +02:00

Conversation 0 Commits 1 Files Changed 11

+99 -10

cesnimda commented 2026-07-02 17:48:45 +02:00

Owner

Copy Link

Copy Source

Recommendation #8 — the last one. Additive cursor, Id tie-break ordering fix, verified vs real Postgres.

🤖 Generated with Claude Code

Recommendation #8 — the last one. Additive cursor, Id tie-break ordering fix, verified vs real Postgres. 🤖 Generated with Claude Code

cesnimda added 1 commit 2026-07-02 17:53:45 +02:00

perf(search): keyset pagination + fix the format-gate line-ending flip-flop ... 01fb74eb38

RECOMMENDATIONS #8: additive AfterSentAtUtc+AfterId cursor — browse windows fetch
via a (SentAtUtc, Id) keyset filter, O(pageSize) at any depth, COUNT skipped
(TotalCount=-1). Adds the Id tie-break to browse ordering (fixes latent
duplicate/skip on equal timestamps). Verified: InMemory continuation test + a
live-Postgres throwaway proving the Guid cursor comparison translates (removed).

Also root-causes the recurring pre-commit/CI format failures: dotnet-format on
Windows defaulted to CRLF while .gitattributes stores LF — the two fought forever.
Adds .editorconfig (end_of_line=lf etc.) so every tool agrees, and normalises the
straggler files. This bug bit three separate commits before being diagnosed.

Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>

cesnimda merged commit 3333e19452 into develop 2026-07-04 16:01:40 +02:00

Sign in to join this conversation.

Reviewers

No Reviewers

Labels

No items

No Label

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

cesnimda

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: cesnimda/Inboxintel#36