Subversion Repositories SmartDukaan

Last modification

• Rev 35536 2026-01-08 16:53:05
• Author: amit

• Log message:

  Optimize fetchParnterStats() - fix N+1 query issues
  
  Performance improvements:
  - Use batch method getAuthUserAndEsclationByPartnerIds() instead of N+1 loop
  - Add new batch method getInvestmentsForFofoStores() to replace N+1 getInvestment() calls
  - Add batch query selectActivatedGrnPendingAmountByFofoIds in ActivatedImeiRepository
  
  Before: ~900 queries for 100 stores
  After: ~7 queries for 100 stores