Subversion Repositories SmartDukaan
(root)/trunk/profitmandi-dao/src/main/java/ – Rev 36302
Rev 36301 | Compare with Previous | Directory listing | View Log | RSS feed
Last modification
- Rev 36302 – 1 d 5 h
- 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.
