Rev 36301 |
Last modification |
Compare with Previous |
View Log
| RSS feed
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.