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
35536 195 d 10 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Optimize fetchParnterStats() - fix N+1 query issues

Performance improvements:
- Use batch method getAuthUserAndEsclationByPartnerIds() instead of N+1 loop
- Add new batch method getInvestmentsForFofoStores() to replace N+1 getInvestment() calls
- Add batch query selectActivatedGrnPendingAmountByFofoIds in ActivatedImeiRepository

Before: ~900 queries for 100 stores
After: ~7 queries for 100 stores		  
35460 214 d 0 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Fix LockAcquisitionException: Add bulk partner type fetch with MAX(base, current_sales) logic

Problem:
- N+1 queries calling getTypeOnDate caused concurrent persist operations
- This led to LockAcquisitionException during high concurrency

Solution:
- Add getTypesForFofoIds() bulk read method for N+1 scenarios
- Add getBaseTypesForFofoIds() to fetch base types (first record of month)
- Implement MAX(base, current_sales) logic:
- Partner can upgrade mid-month based on current sales
- Partner can downgrade from upgrade but NOT below base
- Base type = previous month's sales tier
- Reduce cache from 1 day to 30 minutes for faster upgrade propagation		  
35394 218 d 2 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Improved performance  
33505 753 d 10 h amit.gupta /trunk/ Fixed sanction  
32436 1041 d 19 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ Scheduled Task  
32435 1042 d 11 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ Fixed rbm missing in detailed report  
32430 1042 d 18 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ Fixed front end related issues with add/remove row  
32429 1042 d 18 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ Fixed front end related issues with add/remove row  
32421 1043 d 15 h amit.gupta /trunk/ Added rmbs data in PartnerDetailModel  
31569 1259 d 11 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ Fixed SD Credit  
31567 1259 d 14 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ Fixed Stats logic removed internal ids  
31285 1313 d 12 h tejbeer /trunk/ change  
28617 1834 d 16 h tejbeer /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/  
28377 1897 d 8 h tejbeer /trunk/ chnages  
27907 1965 d 16 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/  
27903 1966 d 10 h tejbeer /trunk/ chnage  
27893 1966 d 16 h tejbeer /trunk/ secondary changes  
27749 1992 d 13 h tejbeer /trunk/ change  
27733 1997 d 11 h tejbeer /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/  
27732 1997 d 11 h tejbeer /trunk/ change  

←Prev12Next→

Show All