Slow Cart, Slow Website

[AlterEgoFitness]

Hi everyone,

I have been trying to fix my websites cart speed for around 3 months now and I am at my witts end. I have been following all of the basic things you find on google really with no luck. When a customer clicks on a product the add to cart will take around 8 seconds to load on the first byte and then when they try again about 5 seconds. This is the same when proceedfing the checkout.

I have done some httaccess rules, used some extensions and stil lno joy, I have paid for a VPS but this is something that is being setup still. my website is www.AlterEgoFitness.co.uk I would love an oppinion 

thanks for reading

[JLHC]

Do you use a lot of extensions? How many products do you have? 

Besides that, what is your current hosting environment and it's specification? What is the specification of your new VPS? 

You may want to implement Magento Profiler to determine what is slowing down your website, especially the Add to Cart page. 

[Stuart M]

TTFB (Time to First Byte) is certainly your problem however it is impossible to diagnose this remotely unless you enable the Varien Profiler in Magento which will expose the PHP functions and SQL queries at the bottom of your website for each page you load.

This is a really good guide on enabling the profiler and what to expect as an output:

http://inchoo.net/magento/keeping-your-magento-fit-with-built-in-profiler/

Once you have done this please share your results here and we will be happy to review for you.

[AlterEgoFitness]

I only have several extensions installed and about 10 products

My VPS is not active yet as we are still setting it up but the website is currently on your basic web hosting package.

A lot of optomisation has been done but we seem to be getting nowhere, here are the results of the compiler when the add to cart button has been pressed:

http://postimg.org/image/5lerxed1n/

http://postimg.org/image/68domx9xn/

http://postimg.org/image/ufy9rgxvv/

http://postimg.org/image/ksurhr4wb/

sorry I could not paste it in as it exceeded 20,000, thanks for the help so far guys

[Stuart M]

Copy and paste that table into Microsoft Excel and sort by the column Time and Cnt.

You want to see which function / call took the most time and or was called the most times as this is normally the first identifier as to the slowness

[AlterEgoFitness]

here we are @Stuart M

http://postimg.org/image/7qacbqjev/

http://postimg.org/image/ws4c8dn8d/

[Stuart M]

Looking at this briefly I would say you have performance issues with your database as layout_dbupdates are taking 4sec combined.

The routes_match 1.9s would also be related to any 3rd party modules you have loading so might want to test your checkout with all modules disabled and then enabled to rule them out.

[AlterEgoFitness]

@Stuart M what would be the best way to clean up the database and by disabling modules do you mean in the mageall.xml file etc and then in the backend under system > config > advanced

[Stuart M]

If you have server access there is a script you can use called "shell/log.php" which allows you to safely clean the database of any rubbish / logs.

Yes under system -> config -> advanced disable manually any non-mage modules. So basically anything 3rd party and then re-test.

[AlterEgoFitness]

@Stuart M it just seems to be the same