View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007860 | OXID eShop (all versions) | 4.05. Performance | public | 2025-11-22 21:06 | 2025-11-22 21:06 |
| Reporter | dirk | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | ||
| Product Version | 7.3.0 | ||||
| Summary | 0007860: lower Performance due to frequent basket calculation | ||||
| Description | By fixing the bug from https://bugs.oxid-esales.com/view.php?id=7391, the load time has significantly deteriorated. Setting the parameter $blForceUpdate to true when calling calculateBasket in the render method of the BasketComponent massively increases the number of SQL queries on category pages. Products on category pages are displayed via ArticleBox widgets, and this causes the basket to be recalculated for every single product. The $blForceUpdate parameter must not be used here, and the bug from the ticket above must be solved in a different way. | ||||
| Steps To Reproduce | 1. Enable the option to save user baskets in the backend. 2. Log in as a user in the frontend. 3. Add at least 10 different products to the cart. 4. Open a category page where at least 12 products are displayed. 5. Monitor load time and the number of SQL queries regarding userbasketitems using profiling tools (Tideways, etc.). I.6ncrease the number of displayed products per category to 24, open a corresponding category with a high product count, and repeat step 5. 7. Set the $blForceUpdate parameter in BasketComponent::calculateBasket() to false and repeat steps 5 and 6. Compare the results from steps 5, 6, and 7. | ||||
| Tags | Basket, Perfomance | ||||
| Theme | Not defined | ||||
| Browser | Not defined | ||||
| PHP Version | Not defined | ||||
| Database Version | Not defined | ||||
