Number of discounts crashes store

Hi,

One of my customers wanted to give discounts to customers. He import 5000 discount codes. After that, application stops working.

Version 3.70

Please got through this or this.

SuperNopCommerce wrote:

Thanks, but:
SuperNopCommerce wrote:
can not add just one code. There is no SQL Server problem (already got Express edition).
And
SuperNopCommerce wrote:
will be fixed in 3.80...

To avoid this problem you have to make the following customiztion:
https://www.nopcommerce.com/boards/t/18705/suggestion-a-simple-way-to-generate-massive-and-personalized-discount-coupons.aspx

The problem is that with that many discounts, nop is going through each discount and every discount requirement every time a page loads so it crashes your site. The only solution for me was to modify the Nop source to assign an ACL to a discount and bypass the user role discount rule. This filtered out all but a few discounts and sped the site back up.

See here:
https://www.nopcommerce.com/boards/t/41594/feature-request-acl-on-discounts.aspx

https://www.nopcommerce.com/boards/t/38345/how-i-improved-a-slow-site-with-hundreds-of-discounts.aspx

I solved it in a bit of an improper way but the client had changed the project deadline from 4 months to 2 months.