Slow Back and Frontend / Understanding Profiling info

[oliiix]

Dear All

 

I have a serious problem about a prestashop 1.6.1.6. installation for the company I'm working for. I just migrated products and customer trees from an osCommerce installation to Prestashop using cart2cart migration service. (between 1200-2000 products)
 

What I got is a website full of products, BUT it's now an extremely slow one. I most of the time run into a 500 error and a timeout entry in the logfile when trying to open any page in the back or front end.

I have enabled all the different caching/ccc options available but it doesn't really have an influence. I enabled profiling and most of the numbers are red, but I cannot figure out what every entry means exactly. Maybe someone of you can read it better and see something odd in there. I attached it to this topic. It doesn't look like any module is the problem...

 

I did a new fresh installation into another subfolder and a second installation to another webhosts server (my private one). Result: It might be the webhoster... The standard installed prestashop pages are running much faster than on the host I'm trying to get it to run, but it would be a huge pain ** *** *** to switch the hosting provider as many other things would have to be changed then...

 

Any guidance to where the problem might be at or how to investigate further are very welcome.

Thanks

Oli

Load Time.pdf

[El Patron]

There is no issue with moving a domain to another hosting, it's just repoint of DNS.

 

to determine if native just slow on your hosting or a 3rd party module dragging you down (which I doubt because slow front and back)

 

is to disable 3rd party modules/overrides to see if 'any' improvement.

 

advanced parms-->performance-->here you can disable 3rd party modules/overrides for your test.

 

also you 'want' to run php 5.6, this has big php performance enhancement..

[oliiix]

Hello El Patron

 

Thank you so much for coming back to me. I duplicated the site to the hoster of my private site and the access speed is the same. So I think it's not really about the hoster and also not about the php version as on my private host php 5.6 is active. I also did a test after disabling the modules/overrides and the page was still slow as snails^^

I tested the page with webpagestest.org which really pointed out that the problem is not caused by any css/js scripts that are executed...:

 

I already have deleted all the orders to check if there's some entry in the orders causing it. That didn't help.

Then I tested all the sql querys that prestashop does when viewing the products and order pages and the querys are executed in no time and quite faster than the shops querys are executed. I'm soooo puzzled...

 

I'm now going to delete all products and check again if it was a product that might causes the page to load that slow... Only so that I did it, not that I'm seriously considering that this might help. I'm also going to check what exactly happens during this time to first byte period (I thought I knew but maybe there's some details I'm not aware of yet)... There must be the problem somewhere when looking at the above picture...

 

I also do not really wanna switch to a dedicated server as we have four other sites out there with more products and more orders which run completely fine on prestashop 1.6.1.3. So this should be achievable somehow or an error of some kind...

 

Thanks for your help! Very appreciated

Oli

Edited September 30, 2016 by oliiix (see edit history)

[Logical IT]

Hello Oliiix,

 

are you testing prestashop in debug mode? If not, put your store in debug mode and see if you get any php errors reporting to the screen.

https://www.prestashop.com/forums/topic/224525-how-to-turn-on-error-reporting-for-debug-information-blank-page-500-internal-server-error/

[El Patron]

run mysql report using phpmyadmin, look for 'things' in red. 

 

knowing 'place' of 500 error with ps debug enabled is critical as that tells you where bottleneck is..tip: never post here you received 500 error...get underlying php error...lol

 

man this is tough, I want to blame server because front/back office slow, and tough because as webmasters we want to get our hands on it and say solved! 20 seconds later....

 

the 500 error time outs, localizing that to real php  error would be 'most' useful.

 

good luck,  I'll follow along. el

[oliiix]

Thank you very much for your efforts and that you were willing to track my progress. I can't thank you enough! I solved the problem by updating to version 1.6.1.7. Somehow it was all about the version 1.6.1.6. that caused it. I can only tell DO NEVER INSTALL version 1.6.1.6. Now everything runs as smooth as it should.