0

I have imported 6.3 million coupon in Magento 2.3. I have performance issues on checkout page. When I apply coupon it takes lot of minutes. How to increase performance ?

I am running database on separate server which is fast and also I have setup glera cluster.

Kirti Nariya
3,0872 gold badges26 silver badges54 bronze badges
asked Mar 25, 2019 at 17:28
5
  • 1
    Make sure you have index for code column in salesrule_coupon table. Commented Mar 25, 2019 at 19:21
  • Why you have created 6.3M Coupon? Commented Mar 26, 2019 at 11:59
  • I do not think Magento can handle it this amount of Coupon Commented Mar 26, 2019 at 12:04
  • 1
    @dudzio it is already there. it is by default. Commented Mar 26, 2019 at 12:44
  • @AmitBera because we have these coupon in old website and i imported all coupon in magento.Then how big websites are handling million of coupons ? Commented Mar 26, 2019 at 12:46

1 Answer 1

0

I updated magento version from 2.3.0 to 2.3.1 and my issue is fixed. Now i have 6.3 millions coupons and on magento latest version i am able to apply coupons without any issue. There is no performance issue in magento2.3.1 version.

answered Mar 28, 2019 at 12:32
1
  • There was a massive performance issue in the SQL Query of former versions of Magento 2, which basically prevented the usage of indexes in the salesrule_coupon table. According to Github the issue will be fixed in 2.3.2 but if you say it’s fixed already, that’s awesome. github.com/magento/magento2/pull/20484 Commented Apr 1, 2019 at 7:44

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.