Hi Dynamicweb,
We experience very poor performance on the Customer Center Order List as to much logic seems to be done by the api and not the database which in the end causes why too many database calls when have many orders on a customer.
- All orders for a customer are loaded from the database even though paging is setup and this is done one by one instead of bundle the queries
- All orderlines for each order (even though paging is set up) are loaded from the database
- And we have no orderline loops on the list template
- All orderlines are loaded twice from the data
- Even the products are loaded seems to be loaded one by one for each orderline and again without accessing the orderline loop
Best regards, Anders
