Hi,

It could be done in the past, at least with the catalog system, but I don't remember any customers of us deployed succesfully with later versions (Commerce 8+). It's however surely complicated to manage.

What are the problems you are trying to solve? Bad performance on some specific areas? There are ways to optimize the site which are simpler and can yield even better results.

.Q

We are having trouble managing an Episerver 10 Commerce website with 25+ millions orders (and they will increase to at least 50 milions orders). These are the issues/concerns we found so far:

1. All Commerce Manager -> Order Management screens (Order Search, Purchase Order - Today, This Week, etc.) are cracking (timeout errors). The "ecf_Serach_OrderGroup", "ecf_Serach_ShoppinCart", "ecf_Serach_PurchaseOrder" stored procedures seem to be the problems, i.e. they are very slow. We are considering trying the following two approaches (in the given order)

   A1. Replacing the stored procedures with some optimized SQL code

   A2. Using a search provider like ElasticSearch to index all the orders and then reuse that index for the Order Management screens

2. We are concerned about the front-end website performance when somebody uses the Order Management screens.

Do you have any suggetions for how handle this amount of orders in Commerce Manager?

Thank you for your response.

Commerce 10.2.0, which is supposed to be released in a couple of weeks from now comes with a new cart system which will significantly improve the cart performance, and also the overall order system performance as well. I would recommend you to try to upgrade to that version to see if the situations improve.

I also suggest you to contact our developer support service. We will look into the timeout errors to see if we can improve something.

Just a note that the new cart system in Commerce 10.2.0 doesn't work with commerce manager. It will work in the nearly future. So, it may not help in the performance case with commerce manager.