Magento Sudden Slow add to cart + Checkout

[bharris]

Hi,
Overnight when an item is added to the shopping cart, cart edited or any checkout procedures are taking a horrendous amount of time (about 9 seconds). Catalog, searches etc are all absolutely working fine. No programming has been changed (as far as i know). Any ideas as to what to look for?
Thanks

 

[goivvy]

hard to say without looking

i suggest you install Profiler - https://github.com/AOEpeople/Aoe_Profiler

just google how to do that

once installed try to add an item to the cart and see profiler output in the backend

there you can find what is taking most of time

 

[zigojacko]

Are you using a third party checkout extension (or any other extensions that come into play at cart/checkout)?

 

[bharris]

Hi Zigojacko,
No its the RWD theme using the standard onepage checkout. I also have the exact same setup on other sites and they are fine. Its just happened overnight. Normally each add to cart/ checkout operation takes less than a second.
Thanks

 

[zigojacko]

Presumably no errors or anything of significance in the browser console?

 

[webhostuk]

Is it just the delay and still working , or you get some error?

 

[bharris]

Hi, Yes no errors that i can see and all works its just very slow.
I have tested it using Chrome (PC), Opera, Safari standard browser on mobile and its all very slow however I have just discovered that when using Firefox and Chrome on my mobile it works fine.
Very odd.

 

[edmondscommerce]

What API integrations are in play

If nothing has changed on your side, then any third party system that yours is depending on is likely to be the culprit.

Things like mailchimp will attach onto "events" in Magento and then fire their code to perform operations on the remote system. If these processes are slow or unreliable then your system suffers as a direct result

 

[APWTrading]

Have you cleared out all the log tables etc, this can be one of the main causes of slow systems espescially in this area ?

 

[Deleted member 106254]

Check how many catalog and shopping cart price rules you have running. Too many and the add to cart process slows to a crawl.

 

[bharris]

Fixed the issue just before a day or so later, the shopping cart was trying to load an external file that no longer existed causing it to stall. Looking at the programming all was ok however the cache wasn't refreshing. Our host cleared all the server caches and the problem went away.
Thanks for your suggestions.

 

[webhostuk]

That's good thinking to resolve such problem .

 

[nguyennham.1012]

Fixed the issue just before a day or so later, the shopping cart was trying to load an external file that no longer existed causing it to stall. Looking at the programming all was ok however the cache wasn't refreshing. Our host cleared all the server caches and the problem went away.
Thanks for your suggestions.

I faced same problem. thank you I have solved!

 

[MarekBober]

Open source suddenly do not work... who will cover the loss? Who can be pointed out as responsible for lost money? There is only one thing in this case sure about money- shop owner have to spent them to get the things fixed. It makes me a bit confused is e-commerce about exploration opportunities of new distribution channels or is about bug fixing and software development? How store can be reliable source of products and services if is not reliable itself.
The case is a bit like you got brilliant car mechanic when sober, he got drunk as random as your car broken- would you put your family into fixed car...

 

[Freshwebservices]

Check how many catalog and shopping cart price rules you have running. Too many and the add to cart process slows to a crawl.

This was a cause of slowness on our site. Reducing active Shopping Cart Price Rules from 16 to 10 knocked c.6 seconds off the load times of Add to Cart & Checkout pages. We're running Mage CE 1.9+.

 

[Mark_Taylor_]

Consider installing newrelic if you can afford it, We use it to monitor every database process, php script and API connection and it really helps pinpoint any problems quickly.