Subversion Repositories SmartDukaan

Last modification

• Rev 37600 2026-09-11 20:40:13
• Author: amit

• Log message:

  Replace entity loads with scalar aggregates in the investment sweep
  
  Order.lineItem is a ManyToOne with FetchType.EAGER, so getInTransitOrders() and
  selectPendingGrnOrders() pulled ~6,865 Order entities plus a LineItem for each
  into the session every two minutes - all dirty-checked at flush - when the sweep
  only reads getRetailerId() and getTotalAmount(). That, plus ~1,690 FofoStore and
  ~984 PartnerInvestment rows, put roughly 17,000 entities in one session per pass
  and is most of the ~10s each sweep was taking.
  
  Adds two scalar named queries returning (retailerId, sum(totalAmount)) grouped by
  partner. A projection never hydrates the entity, so the eager association never
  fires - about 13,700 entities become ~1,000 rows. The predicates copy
  selectOrders(ids, pendingOrderStatus) and selectPendingGrnOrders(ids) exactly,
  including the SD_START_DATE floor, and the comment on the named queries says to
  change them together.
  
  Deliberately NOT done by making lineItem lazy: that mapping is shared by every
  Order consumer in the codebase and flipping it globally is a far wider change than
  this needs.
  
  Entity-returning variants are untouched for their existing callers. Drops the now
  unused sumOrderAmounts helper and the TransactionService dependency.
  
  Not a fix for a problem - the sweep was comfortably inside its 120s window at ~8%
  duty. It removes waste that would matter if the cadence were ever shortened.