perf: bound `listReconciliations` — server-side status filter + pagination #52

New issue

Closed

opened 2026-07-04 12:11:47 +00:00 by momsse · 0 comments

momsse commented

2026-07-04 12:11:47 +00:00

Owner

Migré depuis viziertronic/octant#116 — ouvert le 2026-06-27 par @momsse.

reconciliations.query.adapter.ts runs findAllReconciliations with only WHERE status <> 'archived' — no LIMIT, no pagination, no per-status filter. As reconciliations accumulate across statuses (pending, established, dismissed, skipped, undone), the response payload, decode time and JS heap grow unboundedly. The backoffice list atom is keepAlive, so a stale full snapshot stays resident for the runtime's lifetime.

Follow-up to the #41 review queue (PR #114). Proposed:

a status filter on the listReconciliations RPC (the queue only needs pending by default);
server-side pagination (cursor or offset) on the query adapter;
the backoffice page passes the active status filter + page through.

Surfaced in the #41 review (PR #114).

> _Migré depuis [viziertronic/octant#116](https://github.com/viziertronic/octant/issues/116) — ouvert le 2026-06-27 par @momsse._ `reconciliations.query.adapter.ts` runs `findAllReconciliations` with only `WHERE status <> 'archived'` — no `LIMIT`, no pagination, no per-status filter. As reconciliations accumulate across statuses (pending, established, dismissed, skipped, undone), the response payload, decode time and JS heap grow unboundedly. The backoffice list atom is `keepAlive`, so a stale full snapshot stays resident for the runtime's lifetime. Follow-up to the #41 review queue (PR #114). Proposed: - a status filter on the `listReconciliations` RPC (the queue only needs `pending` by default); - server-side pagination (cursor or offset) on the query adapter; - the backoffice page passes the active status filter + page through. Surfaced in the #41 review (PR #114).

momsse closed this issue

2026-07-04 12:11:48 +00:00

momsse referenced this issue

2026-07-04 12:18:45 +00:00

Introduire ProcessManagerShape pour les sagas de cascade (vocabulaire saga ≠ projector) #22

momsse referenced this issue

2026-07-04 12:18:57 +00:00

perf: bound the banking list RPCs — pagination for listBankTransactions / listBankAccounts #55

momsse referenced this issue

2026-07-04 12:18:59 +00:00

ux: server-side search/filter for the paginated banking lists #61