KamoCRM

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 kitu kinaingia kwenye tovuti yako mwenyewe. Anza kwenye mpango wa bure na usome ukurasa huu tena katika mwezi mmoja.

Kuwa Huru MileleMtazamo wa bei