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
35493 286 d 0 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ N+1 query optimization for B2B order creation flow

- OrderServiceImpl: Batch fetch PendingOrderItems before validation loop (line 402)
- OrderServiceImpl: Batch update opening stock using minusOpeningStockBatch
- OrderServiceImpl: Pre-fetch tagListings and GST rates before createAndGetFofoOrderItem loop
- OrderServiceImpl: Batch fetch PendingOrderItems for status update (line 719)
- CartServiceImpl: Pre-fetch items before getCartValidation loop
- SchemeServiceImpl: Batch fetch SchemeInOut records in processSchemeOut
- SmartCartService: Added minusOpeningStockBatch method for batch updates
- TagListingRepository: Added selectByItemIds batch method
- FofoOpeningStockRepository: Added findByFofoIdAndCatalogIds batch method
- PendingOrderItemRepository: Added selectByIds batch method

Performance improvement: ~70-100 DB queries reduced per order (10 items avg)
 
35394 293 d 21 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Improved performance  
35334 309 d 12 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/ Fixed hard limit  
35252 336 d 11 h aman /trunk/ Feat:Expire Schemes by ids and lead assign to bgc too  
35236 344 d 5 h amit /trunk/ Fixed notification related issues with scheme also stopped using mongo for brands Schema  
35210 356 d 5 h vikas /trunk/ Push Notifications Templates  
35096 372 d 6 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/ Fixed Static  
35060 377 d 23 h amit /trunk/ Fixed wrong notifications going to retailers  
34991 390 d 8 h vikas /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/ Web Pages Management and Notifications Formatting  
34990 390 d 8 h vikas /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/ Web Pages Management and Notifications Formatting  
34989 390 d 8 h vikas /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/ Web Pages Management and Notifications Formatting  
34962 397 d 7 h vikas /trunk/ Web Pages Management and Notifications Formatting  
34902 410 d 3 h vikas /trunk/ Affiliate Order  
34850 430 d 16 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/ Update  
34803 448 d 4 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/ Fixed scheme out  
34802 448 d 4 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/ Will appropriate the in margin when bill is created  
34800 448 d 6 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/ Fixed credited scheme id  
34778 453 d 10 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Fixed rollout for Pardeep telecom  
34750 459 d 7 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/ Special Support would not get added or rejected from processing scheme out  
34746 460 d 9 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/ donotcommit  

Show All