Collapse pipeline kanban N+1 to a single grouped count query

Performancekamo-shared-library
Ya
15 Mei 2026, 20:52 UTC
Mwandishi
Kamo
Ahadi ya
2f09c13

listForOrganization() used to issue one condition-fetch per loan (201 queries at 200 loans). Now a single grouped JPQL aggregate keyed by loanFile.uid projects open and blocking-open counts into LoanConditionCountsRow, and the service merges that map with the apps list — 2 queries regardless of size.

Mabadiliko yote

Je, unaona nini kuhusu usafiri?

Kila moja ya hizi updates ardhi katika nafasi yako ya kazi moja kwa moja. Kuanza bure na kuangalia kukua wiki baada ya wiki.

Kuwa Huru MileleMtazamo wa bei