Subversion Repositories SmartDukaan

Rev

Go to most recent revision | Show changed files | Details | Compare with Previous | Blame | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
36296 177 d 2 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ 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.
 
36284 177 d 21 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ code optimization of today po rbm page  
36276 179 d 0 h ranu /trunk/ unique call and recording will show on dashboard  
36234 184 d 5 h ranu /trunk/ back date data ..........dashboard display on calling  
36229 185 d 22 h ranu /trunk/ rbm l1,l2,l3 layer introduce  
36228 185 d 23 h ranu /trunk/ rbm l1,l2,l3 layer introduce  
36225 185 d 23 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ rbm l1,l2,l3 layer introduce  
36212 186 d 22 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ rbm l1,l2,l3 layer introduce  
36210 186 d 23 h ranu /trunk/ rbm l1,l2,l3 layer introduce  
36181 190 d 23 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ weekly rating system live on calling module  
35852 227 d 21 h ranu /trunk/ call data download  
35843 228 d 19 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ called will come from agent call log instead of remark  
35822 232 d 0 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ show all caleed by auth user  
35821 232 d 0 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ show all caleed by auth user  
35818 232 d 2 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ show all caleed by auth user  
35816 232 d 3 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ calling l2 improve  
35763 240 d 6 h ranu /trunk/ rbm called detail now coming from call log not by remark  
35762 240 d 19 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ rbm calls date wise filter given  
35761 240 d 20 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ rbm calls date wise filter given  
35760 240 d 20 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ rbm calls date wise filter given  

Show All