Magento 2: Cart price rule performance issueHow to apply all valid Shopping Cart Price Rules to quote?Magento 1.9 performance - product with custom optionsDatabase performance issue even on new server. database issue on magento store?strange performance issueApplying No Coupon & Specific Coupon to one Cart?Adding cart costs more than two minutes to respondFrontend incredibly slowImprove performance on SOAP callsMagento 2 strong performance issues (cron)Magento2 - Cart Price Rule & Tier Price Issue

Are taller landing gear bad for aircraft, particulary large airliners?

Superhero words!

I2C signal and power over long range (10meter cable)

Greatest common substring

Can somebody explain Brexit in a few child-proof sentences?

Invariance of results when scaling explanatory variables in logistic regression, is there a proof?

Was the picture area of a CRT a parallelogram (instead of a true rectangle)?

What will be the benefits of Brexit?

Could solar power be utilized and substitute coal in the 19th century?

Freedom of speech and where it applies

Did US corporations pay demonstrators in the German demonstrations against article 13?

For airliners, what prevents wing strikes on landing in bad weather?

Simulating a probability of 1 of 2^N with less than N random bits

Pronouncing Homer as in modern Greek

Simple recursive Sudoku solver

Reply ‘no position’ while the job posting is still there (‘HiWi’ position in Germany)

Lightning Web Component - do I need to track changes for every single input field in a form

What was required to accept "troll"?

Science Fiction story where a man invents a machine that can help him watch history unfold

Can the electrostatic force be infinite in magnitude?

Hostile work environment after whistle-blowing on coworker and our boss. What do I do?

Lifted its hind leg on or lifted its hind leg towards?

In Star Trek IV, why did the Bounty go back to a time when whales were already rare?

Adding empty element to declared container without declaring type of element



Magento 2: Cart price rule performance issue


How to apply all valid Shopping Cart Price Rules to quote?Magento 1.9 performance - product with custom optionsDatabase performance issue even on new server. database issue on magento store?strange performance issueApplying No Coupon & Specific Coupon to one Cart?Adding cart costs more than two minutes to respondFrontend incredibly slowImprove performance on SOAP callsMagento 2 strong performance issues (cron)Magento2 - Cart Price Rule & Tier Price Issue













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.






shopping-cart-price-rules magento2.3 performance







share|improve this question
























  • Make sure you have index for code column in salesrule_coupon table.

    – dudzio
    11 hours ago















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.






shopping-cart-price-rules magento2.3 performance







share|improve this question
























  • Make sure you have index for code column in salesrule_coupon table.

    – dudzio
    11 hours ago













0












0








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.






shopping-cart-price-rules magento2.3 performance







share|improve this question
















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.






shopping-cart-price-rules magento2.3 performance




shopping-cart-price-rules magento2.3 performance






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 4 mins ago









Kirti Nariya

1,013415




1,013415










asked 13 hours ago









Ashar RiazAshar Riaz

507519




507519












  • Make sure you have index for code column in salesrule_coupon table.

    – dudzio
    11 hours ago

















  • Make sure you have index for code column in salesrule_coupon table.

    – dudzio
    11 hours ago
















Make sure you have index for code column in salesrule_coupon table.

– dudzio
11 hours ago





Make sure you have index for code column in salesrule_coupon table.

– dudzio
11 hours ago










0






active

oldest

votes











Your Answer








StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f267305%2fmagento-2-cart-price-rule-performance-issue%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































Thanks for contributing an answer to Magento Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid …


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f267305%2fmagento-2-cart-price-rule-performance-issue%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







-

Popular posts from this blog

Can not update quote_id field of “quote_item” table magento 2Magento 2.1 - We can't remove the item. (Shopping Cart doesnt allow us to remove items before becomes empty)Add value for custom quote item attribute using REST apiREST API endpoint v1/carts/cartId/items always returns error messageCorrect way to save entries to databaseHow to remove all associated quote objects of a customer completelyMagento 2 - Save value from custom input field to quote_itemGet quote_item data using quote id and product id filter in Magento 2How to set additional data to quote_item table from controller in Magento 2?What is the purpose of additional_data column in quote_item table in magento2Set Custom Price to Quote item magento2 from controller

Image
iPad being using in wall mount battery swollen Should I cover my bicycle overnight while bikepacking? Do UK voters know if their MP will be the Speaker of the House? Why can't we play rap on piano? Plagiarism or not? Why didn't Miles's spider sense work before? How to tell a function to use the default argument values? Short story with a alien planet, government officials must wear exploding medallions If human space travel is limited by the G force vulnerability, is there a way to counter G forces? What about the virus in 12 Monkeys? Is it acceptable for a professor to tell male students to not think that they are smarter than female students? Avoiding the "not like other girls" trope? Apex Framework / library for consuming REST services Is there an expression that means doing something right before you will need it rather than doing it in case you might need it? Method Does Not Exist error message How to show a landlord what we have...
Read more

How to solve knockout JS error in Magento 2 Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?(Magento2) knockout.js:3012 Uncaught ReferenceError: Unable to process bindingUnable to process binding Knockout.js magento 2Cannot read property `scopeLabel` of undefined on Product Detail PageCan't get Customer Data on frontend in Magento 2Magento2 Order Summary - unable to process bindingKO templates are not loading in Magento 2.1 applicationgetting knockout js error magento 2Product grid not load -— Unable to process binding Knockout.js magento 2Product form not loaded in magento2Uncaught ReferenceError: Unable to process binding “if: function()return (isShowLegend()) ” magento 2

Image
Does the Pact of the Blade warlock feature allow me to customize the properties of the pact weapon I create? Why isn't everyone flabbergasted about Bran's "gift"? Paektu / Changbai border dispute — why does the BBC shade a large area around the mountain? Is it OK if I do not take the receipt in Germany? How to ask rejected full-time candidates to apply to teach individual courses? /bin/ls sorts differently than just ls What *exactly* is electrical current, voltage, and resistance? Coin Game with infinite paradox Diffie-Hellman with non-prime modulus Example of a central simple algebra Etymology of 見舞い Lights are flickering on and off after accidentally bumping into light switch A journey... into the MIND How to calculate density of unknown planet? How to produce a PS1 prompt in bash or ksh93 similar to tcsh What's the connection between Mr. Nancy and fried chicken? How can I delete rows in the text? How is it possible to imple...
Read more

Nissan Patrol Зміст Перше покоління — 4W60 (1951-1960) | Друге покоління — 60 series (1960-1980) | Третє покоління (1980–2002) | Четверте покоління — Y60 (1987–1998) | П'яте покоління — Y61 (1997–2013) | Шосте покоління — Y62 (2010- ) | Посилання | Зноски | Навігаційне менюОфіційний український сайтТест-драйв Nissan Patrol 2010 7-го поколінняNissan PatrolКак мы тестировали Nissan Patrol 2016рвиправивши або дописавши її

Image
Автомобілі:ПозашляховикиАвтомобілі Nissan укр.автомобільNissanпозашляховиків195119601988двигун1951повнопривідникомамериканськийWillysарміїкузовомпікапиPerkins1987ЯпоніїІспанії2000дизельним ...
Read more