Subversion Repositories SmartDukaan

Last modification

• Rev 36329 2026-04-21 16:05:02
• Author: amit

• Log message:

  Tune rbmWeeklyBilling cache: 2m→5m TTL + sync=true
  
  The RBM weekly billing aggregate query takes ~2s per call (1,924 cumulative hits
  on hadb1 = 3,800s DB time). Previously cached for only 2 minutes with no
  stampede protection — every 2m window, every concurrent dashboard load ran the
  aggregate in parallel and burnt Hikari slots simultaneously.
  
  - 2m → 5m: this is month-level aggregate bucketed by week, doesn't need
  sub-minute freshness for an RBM dashboard.
  - sync=true: single in-JVM computation per (monthStart, monthEnd) key per
  expiry window; concurrent misses wait for the in-flight load instead of
  racing to the DB.
  
  fiveMintimeoutCacheManager already exists in CacheConfig:73 (Caffeine, in-memory,
  so no Redis/LocalDateTime serialization concerns).