Refactor #1570

Improve Performance of Sales Price Caclulations

Added by Pavan Rikhi about 1 year ago. Updated 5 months ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:Pavan Rikhi% Done:

0%

Category:PerformanceSpent time:-
Target version:v2.0.0 - Post-Migration Issues
Easy Pickings:

Description

The category/products views cause many SQL queries because they query for sales for each product/category individually.

Instead, we should fetch all the active sales once & then use them to calculate the final price for each product.

History

#1 Updated by Pavan Rikhi 12 months ago

  • Category changed from Products to Performance

#2 Updated by Pavan Rikhi 11 months ago

Some of this has been done for the merchant feed in server/src/MerchantFeed.hs.

#3 Updated by Pavan Rikhi 11 months ago

  • Target version changed from v1.00.00 - Deployment to v1.01.00 - Coupons Admin

#4 Updated by Pavan Rikhi 11 months ago

  • Target version changed from v1.01.00 - Coupons Admin to v1.03.00 - Avalara & Server Improvements

#5 Updated by Pavan Rikhi 10 months ago

  • Target version changed from v1.03.00 - Avalara & Server Improvements to v1.04.00 - Complete Admin Site

#6 Updated by Pavan Rikhi 8 months ago

  • Target version changed from v1.04.00 - Complete Admin Site to 80

#7 Updated by Pavan Rikhi 5 months ago

  • Target version changed from 80 to v2.0.0 - Post-Migration Issues

Also available in: Atom PDF