We have only a handful of products in our system, but we require thousands of promotion codes. The more codes we have the slower the system gets.
For example, we currently have just over 3,000 codes and adding a code, removing a code, checking out, etc, each takes no less than 10 - 15 seconds to complete. If I remove promotions down to a handful, the performance returns to where I would expect.
I tried adding some indexes to the cscart_promotions and cscart_promotion_descriptions tables but it did not improve the performance.
Other Users:
* Does anyone else have our quantity of promotions?
* Are you performing well or poorly?
csCart:
* Do you know why this might be happening?
* Is there a known limit to the number of promotions the system can handle well?
We are currenlty operating on version 4.1.2.
|