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

Magento 2 duplicate PHPSESSID cookie when using session_start() in custom php scriptMagento 2: User cant logged in into to account page, no error showing!Magento duplicate on subdomainGrabbing storeview from cookie (after using language selector)How do I run php custom script on magento2Magento 2: Include PHP script in headerSession lock after using Cm_RedisSessionscript php to update stockMagento set cookie popupMagento 2 session id cookie - where to find it?How to import Configurable product from csv with custom attributes using php scriptMagento 2 run custom PHP script

Image
In the late 1940’s to early 1950’s what technology was available that could melt a LOT of ice? "One can do his homework in the library" Setting correct UTM zone Time travel short story where dinosaur doesn't taste like chicken Do Bugbears' arms literally get longer when it's their turn? Offered promotion but I'm leaving. Should I tell? Subset counting for even numbers The difference between 時　and 時は String reversal in Python Good allowance savings plan? Do f-stop and exposure time perfectly cancel? What are some noteworthy "mic-drop" moments in math? They call me Inspector Morse Do I really need to have a scientific explanation for my premise? Make a transparent 448*448 image Could a cubesat propel itself to Mars? What is the chance of making a successful appeal to dismissal decision from a PhD program after failing the qualifying exam in the 2nd attempt? Could a cubesat be propelled to the moon? the return of Stri
Read more

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 implement
Read more