44 Seconds to Load: No Changes for 3 months

[techtech]

I'm very curious why my prestashop build takes 10 times longer to load in the last 4 days. The hosting company has performed two tests on load and concluded it's the prestashop script/config.

I have SSL, just removed all Google Analytics modules, updated to 1.6.1.23 from 1.6.1.17 today to try to speed it up.

Anyone experience a dramatic slowdown with Prestashop in the last 4 days? I've used Prestashop for 4 years.

[techtech]

Load Time    37760 ms - You'd better run your shop on a toaster
Querying Time    26365 ms
Queries    212
Memory Peak Usage    20.0 Mb
Included Files    213 files - 3.92 Mb
PrestaShop Cache    - Mb
Global vars    0.46 Mb
PrestaShop Version    1.6.1.23
PHP Version    7.0.32 (OK)
MySQL Version    5.5.60-0+deb7u1-log (Consider upgrading)
Memory Limit    -1
Max Execution Time    50000s
Smarty Cache    disabled
Smarty Compilation    force compile

Time    Cumulated Time    Memory Usage    Memory Peak Usage
config    2874 ms    2874 ms    7.16 Mb    7.44 Mb
__construct    0 ms    2874 ms    - Mb    7.44 Mb
init    1166 ms    4041 ms    2.36 Mb    10.17 Mb
checkAccess    0 ms    4041 ms    - Mb    10.17 Mb
setMedia    3 ms    4044 ms    0.16 Mb    10.17 Mb
postProcess    0 ms    4044 ms    - Mb    10.17 Mb
initHeader    0 ms    4044 ms    - Mb    10.17 Mb
initContent    29431 ms    33475 ms    8.80 Mb    18.71 Mb
initFooter    3258 ms    36732 ms    0.59 Mb    19.12 Mb
display    1027 ms    37760 ms    0.72 Mb    20.02 Mb

 

Hook    Time    Memory Usage
hookdisplayHomeTab    8804 ms    2.00 Mb
hookleftcolumn    6935 ms    - Mb
hookdisplayTop    3840 ms    2.00 Mb
hookfooter    2354 ms    - Mb
hookdisplayTopColumn    238 ms    - Mb
__construct    159 ms    2.00 Mb
hookdisplayHeader    150 ms    2.00 Mb
hookhome    132 ms    - Mb
hookdisplayHome    125 ms    - Mb
hookdisplayFooter    123 ms    - Mb
hookdisplayNav    57 ms    2.00 Mb
hookdisplayHomeTabContent    47 ms    - Mb
hookheader    2 ms    - Mb
hooktop    - ms    - Mb
14 hooks    22968 ms    10.00 Mb

 

 

Module    Time    Memory Usage
homefeatured    8477 ms    2.00 Mb
blocknewproducts    7310 ms    - Mb
blocktopmenu    3843 ms    2.00 Mb
blockcategories    1528 ms    - Mb
statsdata    808 ms    - Mb
themeconfigurator    355 ms    - Mb
homeslider    283 ms    2.00 Mb
blockcmsinfo    133 ms    - Mb
blockbestsellers    130 ms    - Mb
blockcart    54 ms    2.00 Mb
blockcms    16 ms    - Mb
blockmyaccountfooter    7 ms    - Mb
blocklayered    6 ms    2.00 Mb
blocksearch    4 ms    - Mb
blockfacebook    2 ms    - Mb
blockpermanentlinks    1 ms    - Mb
sekeywords    1 ms    - Mb
blockcontactinfos    1 ms    - Mb
crossselling    1 ms    - Mb
blockspecials    1 ms    - Mb
blocksocial    1 ms    - Mb
blockuserinfo    1 ms    - Mb
blockviewed    1 ms    - Mb
blocktags    1 ms    - Mb
blocksupplier    1 ms    - Mb
blockcontact    1 ms    - Mb
productpaymentlogos    1 ms    - Mb
blocklanguages    0 ms    - Mb
blockcurrencies    0 ms    - Mb
pagesnotfound    0 ms    - Mb
blockpaymentlogo    0 ms    - Mb
blockmyaccount    0 ms    - Mb
32 modules    22968 ms    10.00 Mb
Stopwatch SQL
Doubles
Tables stress
ObjectModel instances
Included Files

[El Patron]

if just the back office then remove the gamification module.  if front office also then that won't help.

[joseantgv]

Although probably it isn't the problem, I'd recommend you to update PHP version. Yours will be discontinued next week.

Then your problems are here:

Quote

hookdisplayHomeTab    8804 ms    2.00 Mb
hookleftcolumn    6935 ms    - Mb
hookdisplayTop    3840 ms    2.00 Mb
hookfooter    2354 ms    - Mb

Check which modules are hooked in these positions, and disable them one by one.

[techtech]

Thanks for the tips. I have used PHP5.6 and PHP7.0 for speed testing on 1.6.1.23 with, no positive changes.

I've upgraded to 1.7.4.4 and using PHP7.2. The BO is usable but takes 35 seconds to go to any config page; modules, customers, etc.

This will be my 5th year with Prestashop and the BO is extremely slow compared to any year. No external modules installed and since it's the BO I wonder why the lag now?

A fix for me might be a huge benefit for future users imo...

 

[techtech]

Here is the latest debug data for just loading the dashboard. (I used the Prestashop Cleaner and upgraded all modules before the debugger.) 38 seconds to load the dashboard: 

 

Load Time    38706 ms - You'd better run your shop on a toaster
Querying Time    5972 ms
Queries    43
Memory Peak Usage    30.2 Mb
Included Files    718 files - 7.85 Mb
PrestaShop Cache    0.35 Mb
Global vars    1.19 Mb
PrestaShop Version    1.7.4.4
PHP Version    7.0.32 (Consider upgrading)
MySQL Version    5.5.60-0+deb7u1-log (Consider upgrading)
Memory Limit    -1
Max Execution Time    50000s
Smarty Cache    disabled
Smarty Compilation    auto
   

 Time    Cumulated Time    Memory Usage    Memory Peak Usage
config     4637 ms     4637 ms     18.18 Mb     18.28 Mb
__construct     0 ms     4637 ms     - Mb     18.28 Mb
init     1145 ms     5782 ms     4.48 Mb     23.98 Mb
checkAccess     0 ms     5782 ms     - Mb     23.98 Mb
setMedia     3 ms     5785 ms     0.39 Mb     23.98 Mb
postProcess     0 ms     5785 ms     - Mb     23.98 Mb
initHeader     31743 ms     37528 ms     1.01 Mb     24.04 Mb
initContent     1173 ms     38701 ms     5.50 Mb     30.18 Mb
initFooter     0 ms     38701 ms     0.02 Mb     30.18 Mb
display     5 ms     38706 ms     0.44 Mb     30.22 Mb

 

Hook     Time     Memory Usage
0 hooks     - ms     - Mb
Module     Time     Memory Usage
0 modules     - ms     - Mb

 

[techtech]

 Time    Cumulated Time    Memory Usage    Memory Peak Usage
config     4637 ms     4637 ms     18.18 Mb     18.28 Mb
__construct     0 ms     4637 ms     - Mb     18.28 Mb
init     1145 ms     5782 ms     4.48 Mb     23.98 Mb
checkAccess     0 ms     5782 ms     - Mb     23.98 Mb
setMedia     3 ms     5785 ms     0.39 Mb     23.98 Mb
postProcess     0 ms     5785 ms     - Mb     23.98 Mb
initHeader     31743 ms     37528 ms     1.01 Mb     24.04 Mb
initContent     1173 ms     38701 ms     5.50 Mb     30.18 Mb
initFooter     0 ms     38701 ms     0.02 Mb     30.18 Mb
display     5 ms     38706 ms     0.44 Mb     30.22 Mb

[techtech]

Note: When clicking to view the "Shopping Carts" it produces the longest load time of any process. Triple the other pages; modules and services, orders, etc.

[razaro]

Check your  database and size of tables, maybe some of them over the years got really big.

 

[techtech]

Razaro, thanks for the tip. Can you describe how to view and accomplish a reduction? I will follow up with feedback for future readers. Thanks in advance.

Used the below sql query but will need to learn how to interpert the results:

show table status from "myDatabaseName";

Edited November 27, 2018 by techtech (see edit history)

[techtech]

Update: I simply clicked in phpMyAdmin on the database name and as all the tables were listed I sort by size. Here are the 4 largest:

    ps_connections_source 376,183    InnoDB    utf8_general_ci    81.8 MiB    -
    ps_connections              436,559    InnoDB    utf8_general_ci    53.1 MiB    -
    ps_guest                          432,034    InnoDB    utf8_general_ci    45.1 MiB    -
    ps_pagenotfound            93,741    InnoDB    utf8_general_ci    8 MiB    -

[BlackEdition]

Hey, im not an expert on these things but I have a suggestion.

Have you tried installing a fresh version of 1.7.4.4 in a separate subdomain under the same hosting just to see how fast it is? that way you can eliminate whether the issue is with your host or your main 1.6 PS files.

Good luck

[techtech]

The issue is resolved. I uploaded the files and database to Godaddy and everything returned to normal speed I've enjoyed for over 4 years.

1and1/Ionos went through a merge or something in the latest couple months and it's time to leave that party.

Thank you all for your suggestions. You improved my life ;)

[BlackEdition]

52 minutes ago, techtech said:

The issue is resolved. I uploaded the files and database to Godaddy and everything returned to normal speed I've enjoyed for over 4 years.

1and1/Ionos went through a merge or something in the latest couple months and it's time to leave that party.

Thank you all for your suggestions. You improved my life

If you don't mind me asking, what hosting solution did you choose with GoDaddy? is it the shared web hosting and If so, which plan exactly did you choose and how is it going for you so far?

I've been using GoDaddy for over 5 years and I regularly notice slow load times even though my website has very few visitors (not a prestashop website). Could be a poorly optimized website, but im not sure who to blame.

Edited November 28, 2018 by BlackEdition (see edit history)

[techtech]

I chose the deluxe shared hosting and have stopped using/recording stats. Some tables in the database with stats are big and not needed like visitor origin as I'm happy with Google Analytics.

Best of luck, just keep an eye on database sizes and other website resources that might increase load times.

[sumsel]

Took me a while to figure out what this profiler is. Then I was glad to see I have a unicorn instead of a toaster!

 

Load Time	173 ms - Unicorn powered webserver!
Querying Time	22 ms
Queries	119
Memory Peak Usage	11.3 Mb
Included Files	469 files - 7.04 Mb
PrestaShop Cache	- Mb
Global vars	0.29 Mb

PrestaShop Version	1.7.4.4
PHP Version	7.2.12 (OK)
MySQL Version	5.5.60-MariaDB (Consider upgrading)
Memory Limit	128M
Max Execution Time	30s
Smarty Cache	enabled
Smarty Compilation	force compile

 

Fairly small shop and just setting it up new, running on bitpalace.com / bitpalast.net, german Hoster, I am not affiliated in any way with the hoster but out of the two I tried, they were faster.

Maybe there is a better place to post individual experiences with hosters?