Improve Performance of Sales Price Caclulations
|Assignee:||Pavan Rikhi||% Done:|
|Target version:||v2.0.0 - Post-Migration Issues|
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.