Eliminate full-table scan and N+1 queries on leads endpoint

Ya

11 Machi 2026, 18:48 UTC

Mwandishi

Kamo

Ahadi ya

5fc12c8

- LeadRepository: add findByOrganizationId JPQL query (uses ORG_ID index) instead of loading entire LEADS table and filtering in Java - LeadCustomFormDataRepository: add findByLeadIn for batch loading custom form data for multiple leads in one query - **************** use new repo query; batch-load vendor products with findAllById + map lookup instead of N findById calls - LeadService: add **************** for batch use by the controller For 100 leads this reduces DB queries from ~200 to 3.