johnnyq e92c5cee2f Speed up one account's Transactions, the Transactions and Income counts and totals, and Reconcile: the balance after each line on one account no longer comes from a running total over the account's whole history, accountLedgerBalances giving each line on the page the account's balance from accountBalanceSql less the lines after it, or oldest first the opening balance and the lines up to it, reading only the lines from the page's edge date on and adding up in cents, which lets one account's lines page newest first through listNewestFirst too; the ledger SQL is split into accountLedgerLinesSql, one SELECT naming its columns for payments, revenues and expenses, and accountLedgerWrapSql, with accountLedgerSql their UNION ALL as before and still used with the balance by the export, and the new accountLedgerTotals takes counts and sums over each part and adds them up in cents because a UNION in a derived table is written out whole before it is counted, used for the Transactions pills and totals and Reconcile's uncleared count and later lines; Income gets incomeLinesSql and incomeTotals the same way for its pills, total and incomeTotal; checked against the pushed ledger in every column on every account, over 34 filter sets for the totals, and against the old pages over 119 Transactions, Reconcile and Income combinations on four accounts with transfers, reimbursements and reconciliations; update the 26.11.8 changelog section

2026-11-13 13:17:59 -05:00

34 KiB

Raw Permalink Blame History

View Raw