Subversion Repositories SmartDukaan

Last modification

• Rev 36291 2026-04-17 13:16:51
• Author: amit

• Log message:

  Optimize slow DB queries: split fan-out join, FORCE INDEX on wallet history
  
  - CurrentInventorySnapshotRepositoryImpl.getSpilitStockBatch: split
  LEFT-JOIN fan-out into two independent aggregates (~8x faster);
  fixes SUM(DISTINCT) undercounting bug where same availability/qty
  values across items collapsed into one.
  - UserWalletRepositoryImpl.getWarehousewiseCollection: HQL -> native
  SQL with FORCE INDEX(idx_uwh_wallet_timestamp) so timestamp range
  filters at index level instead of row filter (~4x faster, 3.1s -> 722ms).
  - PartnerCollectionPlanRepositoryImpl.getCommitmentCollectionSummary:
  Criteria 3-Root CROSS JOIN -> explicit INNER JOIN + FORCE INDEX
  (idx_uwh_wallet_timestamp) (~3.5x faster).