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

Closed
opened 2026-07-04 12:11:51 +00:00 by momsse · 0 comments
Owner

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

The banking read RPCs (listBankTransactions, listBankAccounts) query their full read tables with no LIMIT/cursor (e.g. SELECT … FROM read.bank_transactions ORDER BY value_date ASC). A real account with years of history loads every row into one RPC response and decodes it client-side; the backoffice list atom is keepAlive, so the snapshot stays resident.

Read-side analogue of #52 (reconciliation list). Proposed: introduce pagination params on the banking list RPCs (payload: Schema.Void → a PaginationParams payload) and a cursor/limit in the query adapters; the /banking page passes page/cursor through. Doing the RPC-schema part early avoids a breaking change later.

Surfaced in the #41 banking read-surface review (PR #119).

> _Migré depuis [viziertronic/octant#120](https://github.com/viziertronic/octant/issues/120) — ouvert le 2026-06-27 par @momsse._ The banking read RPCs (`listBankTransactions`, `listBankAccounts`) query their full read tables with no `LIMIT`/cursor (e.g. `SELECT … FROM read.bank_transactions ORDER BY value_date ASC`). A real account with years of history loads every row into one RPC response and decodes it client-side; the backoffice list atom is `keepAlive`, so the snapshot stays resident. Read-side analogue of #52 (reconciliation list). Proposed: introduce pagination params on the banking list RPCs (`payload: Schema.Void` → a `PaginationParams` payload) and a cursor/limit in the query adapters; the `/banking` page passes page/cursor through. Doing the RPC-schema part early avoids a breaking change later. Surfaced in the #41 banking read-surface review (PR #119).
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
momsse/octant#55
No description provided.