Subversion Repositories SmartDukaan

Last modification

• Rev 35493 2025-12-24 23:10:03
• Author: amit

• Log message:

  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)