Prestashop Slow Server Diagnostics

“prestashop database slow TTFB”
“prestashop 1.6 shopping cart slow”

TTFB rediculously slow

dd180fa4dbc9f9e7e3fdc9d9bf65b91a

Tried:

  1. Turning off CPHULK running on dedicated server WHM
  2. Optimise database tables – via ssh login – mysql command line
  3. Set all caching off on the Performance page (admin), except Smart Cache ccc (css,java).
    You memory limit (95M) is too low to use advanced caching.
    there is a bug with PS 1.5.4.1 in how it works with memcached which may drastically effect
    PS CACHE BUG: http://forge.prestashop.com/browse/PSCSX-7149
  4. Turn off all cart rules

Didn’t try:
4. Using FastCGI to process PHP – Reduce TTFB
5. Using Amazon CloudFront CDN

Solution:
It was all of these:
– turning all cache off
– doing a database tables optimised from SSH
– turn off all cart rules

SUPPORT

Hi Sam,

Was good speaking to you earlier – just so we have a history in the ticket:
I’ve run the mySQL database check, repair and optimisation on all databases on the server.
While that was underway – you have disabled caching on the site and also removed the cart rulesets
The site is now loading much faster – with an average page load time for me being 1.56.
If there are any other issues – please let me know.
Take care – have a great evening

Kind Regards,
Tremayne Sargeant
Technical Support

Refs:
https://www.prestashop.com/forums/topic/253785-solved-impossibly-slow-loading-pages-time-to-first-byte-7-seconds/
http://www.creativedevelopment.com.au/web-design/reducing-time-to-first-byte-ttfb/
https://www.prestashop.com/forums/topic/392502-improve-performance-add-products-to-cart-is-so-slow/

Sam Deering is a web developer from England (currently living in Australia). In his spare time he enjoys coding, playing chess, reading and investing.

One thought on “Prestashop Slow Server Diagnostics

Leave a Reply

Your email address will not be published. Required fields are marked *