Subversion Repositories SmartDukaan

Last modification

• Rev 36302 2026-04-17 18:15:45
• Author: amit

• Log message:

  Add 2-min cache on Catalog.selectAllGoodStockBrandWise
  
  Hottest query right now on the DB: 3851 execs x 297ms = ~1143 s over
  2.9h uptime. Fired once per target-slab in TodayOfferServiceImpl's
  findAllTodayOffer loop whenever the slab has no explicit catalog IDs.
  
  Input is a single String brand (only ~10 brands), output is a list of
  Catalog entities with no associations (all primitive/String columns,
  no lazy-init risk) and the caller only invokes getBrand/getId on the
  results. Safe to cache in the existing in-memory Caffeine
  twoMintimeoutCacheManager.
  
  Default Spring key (= brand) is stable; unless skips empty results.