When a I customer buy something in our e-commerce store, after the customer select, FINISH ORDER, takes more than 40 seconds to create a order.
Our table isc_orders, have 85Mb and about to 80K lines.
I realized that, if I clean this specific table, the process to finish a order takes less than 2 seconds.
The problem is related to this table, and I would not like to miss the customer order history.
Therefore I am looking to a solution for the customer to don´t experience any slowness when buying at our website, but keeping his order history. Cleaning the db isn´t a solution.