Subversion Repositories SmartDukaan

Last modification

• Rev 36296 2026-04-17 15:23:56
• Author: amit

• Log message:

  Add 2-min cache on dashboard-family queries
  
  Three queries dominate dashboard DB time (~830 s / 30 min combined) because
  they re-execute on every dashboard refresh with near-identical parameters:
  
  - OrderRepositoryImpl.selectPartnersBilledBetweenDates: dynamic endDate is
  LocalDateTime.now(), so cache key bucketed to 2-minute boundaries via SpEL
  (endDate.toEpochSecond / 120) so calls in the same bucket share an entry.
  - UserWalletRepositoryImpl.getPartnerWiseCollectionAchievement and
  RbmTargetServiceImpl.getWeeklyBillingDataForMonth: default Spring key
  (fofoIds + startDate) is stable, no bucketing needed.
  
  All three use the existing Caffeine 'twoMintimeoutCacheManager' (in-memory,
  per-JVM, expireAfterWrite=2min). unless clause skips caching empty results
  so legitimately-empty responses don't pin a bad entry.