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 97 d 4 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 98 d 0 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ code optimization of today po rbm page  
36276 99 d 3 h ranu /trunk/ unique call and recording will show on dashboard  
36234 104 d 7 h ranu /trunk/ back date data ..........dashboard display on calling  
36229 106 d 0 h ranu /trunk/ rbm l1,l2,l3 layer introduce  
36228 106 d 1 h ranu /trunk/ rbm l1,l2,l3 layer introduce  
36225 106 d 1 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ rbm l1,l2,l3 layer introduce  
36212 107 d 0 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ rbm l1,l2,l3 layer introduce  
36210 107 d 1 h ranu /trunk/ rbm l1,l2,l3 layer introduce  
36181 111 d 1 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ weekly rating system live on calling module  
35852 148 d 0 h ranu /trunk/ call data download  
35843 148 d 22 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ called will come from agent call log instead of remark  
35822 152 d 3 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ show all caleed by auth user  
35821 152 d 3 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ show all caleed by auth user  
35818 152 d 5 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ show all caleed by auth user  
35816 152 d 6 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ calling l2 improve  
35763 160 d 8 h ranu /trunk/ rbm called detail now coming from call log not by remark  
35762 160 d 22 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ rbm calls date wise filter given  
35761 160 d 22 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ rbm calls date wise filter given  
35760 160 d 22 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ rbm calls date wise filter given  

Show All