Enormous loading time

[mizuplus]

Hi, I have real problem to configure prestashop to work normal right now it have loading time about 10 - 20 seconds. When you check DEBUG INFO: you note that prestashop make about 1000 SQL queries that take around 6 seconds. I already turn caching on as you can see in My performance but it still make that 1000 queries and Total cache size is still zero.

 

 

 

web: http://mizuplus.eu/newslovakiawine

 

My performence:

 

                SMARTY

Template compilation - Force compilation

Cache - YES

Caching type - MySQL

Clear cache -Clear cache everytime something has been modified

 

                DEBUG MODE

Disable non PrestaShop modules - NO

Disable all overrides - NO

 

                OPTIONAL FEATURES

Combinations - YES

Features - YES

Customer Groups - YES

 

                CCC (COMBINE, COMPRESS AND CACHE)

Smart cache for CSS - YES

Smart cache for JavaScript - YES

Minify HTML - YES

Compress inline JavaScript in HTML - YES

Move JavaScript to the end - YES

Apache optimization - YES

 

                MEDIA SERVERS (USE ONLY WITH CCC)

None

 

                CIPHERING

Algorithm - Use Rijndael with mcrypt lib.

 

                CACHING

Use cache - YES

Caching system - Memcached 

 

 

DEBUG INFO:

 

Load time: 9095 ms

You'd better run your shop on a toaster

Execution            Load time (ms)

config                    326

constructor         0

init                          53

checkAccess       0

setMedia             9

postProcess       0

initHeader           0

initContent         7631

initFooter            224

display                  852

 

Hook processing: 8049 ms / 46.28 Mb

113 methods called in 38 modules

Hook                                                     Processing

displayHome                                      26.70 Mb in 6536 ms

displayHeader                                   15.20 Mb in 580 ms

displayTop                                          1.77 Mb in 514 ms

displayFooter                                    0.41 Mb in 224 ms

displayNav                                          0.26 Mb in 123 ms

moduleRoutes                                  1.81 Mb in 64 ms

displayProductListReviews          0.11 Mb in 6 ms

displayProductListFunctionalButtons      0.01 Mb in 1 ms

displayBanner                                   - Mb in 0 ms

displayHomeTab                              - Mb in 0 ms

displayProductDeliveryTime       - Mb in 0 ms

actionFrontControllerSetMedia - Mb in 0 ms

displayTopColumn                           - Mb in 0 ms

actionDispatcher                              - Mb in 0 ms

displayProductPriceBlock             - Mb in 0 ms

displayHomeTabContent              - Mb in 0 ms

DisplayOverrideTemplate            - Mb in 0 ms

 

Memory peak usage: 63.0 Mb

Execution            Memory (Mb)   Total (Mb)

config                    12.30                     12.3

constructor         -                              12.4

init                          4.04                        16.4

checkAccess       -                              16.4

setMedia             0.22                        16.6

postProcess       -                              16.6

initHeader           -                              16.6

initContent         43.71                     61.2

initFooter            0.42                        61.2

display                  1.17                        63.0

 

Total cache size in Cache class: - Mb

Smarty cache: enabled

Smarty compilation: force compile

SQL Queries: 1388 queries in 5630 ms

Included files: 261 (4.50 Mb)

 

Global vars : 0.72 Mb

$_MODULES ≈ 293k

$context ≈ 218k

$_LANG ≈ 198k

$_SERVER ≈ 13k

$_MODULE ≈ 6k

$_COOKIE ≈ 2k

[selectshop.at]

Disable memcache. This is not a good caching system. You should better use one serversided winch is:

 

fast-cgi + opcode or APC Cache for versions under PS 1.6.1.0

For PS version 1.6.1. - opcode + fast-cgi only and/or nginx engine.

 

By activating debug modus (not SQL debug modus - cause you activated sql debug modus) are you having some other errors ?

Edited July 26, 2015 by selectshop.at (see edit history)

[selectshop.at]

Check here speed test: http://www.webpagetest.org/result/150726_R1_H39/1/details/

 

You server could be have an optimization for to run with Prestashop.Images are not compressed and Cache is not working well - this why I told you to use another caching method instead of memcache.

[mizuplus]

Hi thanks for quick reply I try option with no caching with same result maybe it was a bit faster 1-2 seconds but still loading time was around 8-12 seconds.

Than I check in hosting provider that he have memcached default, file system, and own solution but I have no idea how to setup fast-cgi + opcode or APC Cache.

After I try change caching to file system loading time start jumping from 4 - 56 seconds.

 

Forgot to mention that Prestashop version is 1.6.0.14.

 

I activate DEBUG  PROFILING not SQL MODE and than DEV MODE and I did not seen any errors.

 

I try that speed test and this is result http://www.webpagetest.org/result/150726_PH_TH5/1/details/#request3

Edited July 26, 2015 by mizuplus (see edit history)

[selectshop.at]

APC, fast-cgi, opcode - these are all settings of the server and the server admin should know how to set. So please ask your provider for help to optimate speed on your site, cause it is a server problem, not a Prestashop one.

 

Perhaps there is nothing to do if you are hosing on a shared webspace. so you take into consideration to change your hosting to a VPS or a expensive dedicated server.

 

Furthermore on speed test I can see that you are running on an ngnix ???

HTTP/1.1 200 OK
Server: nginx

Sorry but the one who configured your server is a noob.... On nginx and this bad response time, with big TTFB (time to first byte) response ??? I cannot believe. This is a reason more to contact your provider. He should optimate the bottle-necs he is having on his network/server.

 

The other thing what I see, is that you are using not default theme, but leo_wine. It could be that the theme is causing bottle-necks. You should test on a second envoirment (clone of your shop), if with default theme you have more speed. Third party addons (themes, modules) bad coded are the most reason for speed loss and/or errors.

 

CCC (COMBINE, COMPRESS AND CACHE) - is all set to yes with this second speed test you have done ? This should be all activated, but the cache (memcache) deactivated.

Edited July 27, 2015 by selectshop.at (see edit history)

[mizuplus]

Hi, I email provider so will see what they will do. I try before VPS in another provider with same result. Dedicated server will be too expensive...

 

Second test was with a bit deferent configuration with CCC 3x yes 3x no and Caching none

 

I try another config with

Smarty 

Caching type  - MySQL

 

CCC

3x yes

3x no

 

Caching

Caching system - File System

Depth - 1

 

with this result http://www.webpagetest.org/result/150727_GY_E27/

 

And another config

Smarty 

Caching type  - MySQL

 

CCC

6x yes

 

Caching - no

 

with this result http://www.webpagetest.org/result/150727_77_GPY/

[selectshop.at]

First of all you should compress all your images before you upload them to the server. for ex. with Caesium.  Your images are too big and taking too much loading time.

 

CCC should be all set to YES, EVER for to gain some more optimization.

 

For that, that you are running on nginx, there are several improvements your server provider should do. It is a shame to have such bad loading times on an nginx.

One of my shop, approx. 10.000 products and 300.000 filter options loaded on each category page, I'm having not more than 4 seconds loading for the whole page on nginx machine !!

 

 

 

The other thing what I see, is that you are using not default theme, but leo_wine. It could be that the theme is causing bottle-necks. You should test on a second environment (clone of your shop), if with default theme you have more speed. Third party addons (themes, modules) bad coded are the most reason for speed loss and/or errors.

 

 

For to see if your theme is having bottle-necks you should clone your site and use under the same circumstances the default theme and default modules for to debug server problems. Debugging with foreign themes should be made after improved the page on your server. Bad coded themes could be responsible for great speed loss.

[mizuplus]

Hi, I apology for long time response but I getting ready for holiday. And I will come in 6 days from today so I will not response.

 

But back to shop, I made copy of shop a set default theme disable everything what is not from prestashop modules overrides etc.

 

And result is http://www.webpagetest.org/result/150728_T6_12MD/ 

 

I also contact provider about problem and he told me that this is shared hosting so it is not possible to set APC caching and also note that prestashop making lot of queries to database what was around 1300.

 

With default theme queries are around 190 what is really less than before. But I done some testing and TTFB is still about 5 seconds what is realy bad.

 

Here is link it is print screen http://www.mizuplus.eu/newslovakiawine/swtesting.jpg

Edited July 28, 2015 by mizuplus (see edit history)

[selectshop.at]

Unfortunately this is a server problem, or a bottle neck somewhere in network (backbone, servers bad connected, etc.). At this point I cannot give you more support on this, you should take into consideration to change your package to a better/more flexible one or change your server provider.

[mizuplus]

Thank you anyway. One last question where is your site hosted what you mention before?

[selectshop.at]

On OVH VPS Cloud Classic. Self install, self configuration and use of opcache + fast-cgi + nginx.

Edited August 3, 2015 by selectshop.at (see edit history)