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
35761 141 d 19 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ rbm calls date wise filter given  
35760 141 d 19 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ rbm calls date wise filter given  
35759 141 d 19 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ rbm calls date wise filter given  
35757 141 d 21 h ranu /trunk/ rbm calls date wise filter given  
35730 143 d 3 h ranu /trunk/ rbm calls date wise filter given  
35721 144 d 4 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ code commit for calling target / retailer contact  
35720 144 d 4 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ code commit for calling target / retailer contact  
35714 144 d 21 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ code commit for calling target / retailer contact  
35702 144 d 22 h ranu /trunk/ now recording also fetching  
35677 147 d 3 h ranu /trunk/ code commit for calling target / retailer contact  
35672 147 d 20 h ranu /trunk/ code commit for calling target / retailer contact  
35670 147 d 21 h ranu /trunk/ code commit for calling target / retailer contact  
35669 147 d 22 h ranu /trunk/ code commit for calling target / retailer contact  
35665 148 d 1 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ code commit for calling target / retailer contact  
35662 148 d 22 h ranu /trunk/ code commit for calling target / retailer contact  
35654 150 d 4 h ranu /trunk/ code commit for calling target / retailer contact  
35645 152 d 1 h ranu /trunk/ code commit for calling target  
35631 154 d 3 h ranu /trunk/ code commit for calling target  
35454 196 d 1 h amit /trunk/ perf: Optimize N+1 queries and reduce stream iterations in today_po and today_po_rbm endpoints

MonitorController.java:
- Consolidate 12 stream ops on rbmArrViewModels into single loop
- Consolidate 6 stream ops on sold15daysOldAgingModels into single loop
- Consolidate 6 stream ops on weeklyBillingData into single loop
- Merge double iteration loops into single pass operations
- Replace containsKey+get patterns with computeIfAbsent/getOrDefault
- Add extractRbmNames() helper to eliminate duplicated stream operations

CsServiceImpl.java:
- Fix N+1 in getAuthUserIdAndAuthUserMap using batch selectByIds
- Fix N+1 in getTicketIdAndAuthUserMapUsingTickets using batch selectByIds
- Fix N+1 in getAuthUserIdAndAuthUserMapUsingPositions using batch selectByIds
- Fix N+1 in getCategoryIdAndCategoryUsingPositions using batch selectAll
- Fix N+1 in getRegionIdAndRegionMap using batch selectAll
- Fix N+1 in getAuthUserByPartnerId using batch selectByIds
- Fix double N+1 in getAuthUserAndEsclationTypeByPartnerId
- Fix N+1 in authUserpartnerIdMap using selectByPositionIds
- Fix N+1 in getAuthUserIdPartnerIdMappingByCatIds
- Fix N+1 in getAuthUserIdPartnerIdMapping

RbmTargetServiceImpl.java:
- Fix O(n*m) stream filter in getRbmTodayArr using pre-built lookup maps
- Fix O(n*m) stream filter in setMovementWiseRbmTargets using pre-built maps

today_po.vm:
- Optimize template lookups with single get instead of containsKey+get		  
35453 196 d 2 h amit /trunk/ Optimize /indent/today_po_rbm endpoint - reduce DB queries by ~99%

- Consolidate 5 weekly billing queries into 1 using SQL CASE statements
- Add RbmWeeklyBillingModel for consolidated weekly billing data
- Batch fetch partner collection remarks to avoid N+1 queries
- Batch fetch collection map for all fofoIds to avoid N+1 queries in nested loop
- Reduces ~1160 queries to ~10 queries for 50 RBMs		  

←Prev12Next→

Show All