[solved] My shop www.wedding-shop.com is too slow. Please help!

[lionna]

Dear all,

I am terribly looking for a solution to make my shop load faster. I have made some tests with FireFox Addin Web developer and with Pingdom, and it shows, that the average load time is 11 sec. I see a blackout for about 7000 ms at the beginning - nothing happens at this time, and then everything is loaded.

The CPU tells me, that the resources at this blackout are used for mysqld.

The compilation of template is switched off.

I don't know how to proceed. Can anyone please advise me?

Thanks,
Lionna

[El Patron]

The compilation of template is switched off.

Thanks,

Lionna

 

Hi Lionna,

 

When you say compilation of template is switched off, please be more specific or use screen shots (best).

 

 

Here is something you can do.  

 

Turn on PrestaShop debug profiling.  This is a useful tool to help tell much information about processing a page load:

 

open file config/defines.inc.php and set value true

define('_PS_DEBUG_PROFILING_', false);

 

visit a page you are interested in, scroll to the bottom. Collect this information for analysis and set value back to false.

 

tip: when deubug profiling is set to true, all visitors back and front office will execute.  So get info and set to false (maint mode is also other option).

 

tip(2): disable block layered, check speed

 

state your ps version please.

[Naldinho]

What do you mean by blackout at the beginning? 

 

Typically if there is a long delay before you start getting any data then the problem is your hosting.

[lionna]

Hi guys,

 

many thanks for your hints. With disabling template recompilation I meant the option "Never recompile template files" in Template cache in Menu Advanced Parameters --> Performance.

 

My prestashop version is 1.5.6.1

 

I have run the site in a debug mode, here's what I've got:

 

Load time: 7.655s
You'd better run your shop on a toaster

• config: 83ms
• constructor: 0ms
• init: 26ms
• checkAccess: 0ms
• setMedia: 2ms
• postProcess: 0ms
• initHeader: 0ms
• initContent: 7.192s
• initFooter: 99ms
• display: 252ms

Hook processing: 7.313s / 26.41 Mb

• displayTop: 4.55s / 5.42 Mb
• displayHome: 2.416s / 2.01 Mb
• displayHeader: 182ms / 14.28 Mb
• displayFooter: 99ms / 1.71 Mb
• displayRightColumn: 34ms / 0.83 Mb
• moduleRoutes: 22ms / 1.88 Mb
• displayLeftColumn: 10ms / 0.28 Mb
• DisplayOverrideTemplate: 0ms / 0 Mb
• actionObjectAddBefore: 0ms / 0 Mb
• actionFrontControllerSetMedia: 0ms / 0 Mb
• actionDispatcher: 0ms / 0 Mb
• actionObjectAddAfter: 0ms / 0 Mb
• actionObjectConnectionAddAfter: 0ms / 0 Mb
• actionObjectConnectionAddBefore: 0ms / 0 Mb

Memory peak usage: 36.7 Mb

• config: 7.84 Mb (7.9 Mb)
• constructor: 0 Mb (7.9 Mb)
• init: 2.76 Mb (10.7 Mb)
• checkAccess: 0 Mb (10.7 Mb)
• setMedia: 0.15 Mb (10.8 Mb)
• postProcess: 0 Mb (10.8 Mb)
• initHeader: 0.01 Mb (10.8 Mb)
• initContent: 22.85 Mb (34.1 Mb)
• initFooter: 1.72 Mb (35.7 Mb)
• display: 0.34 Mb (36.7 Mb)

Total cache size (in Cache class): 0 Mb

DB type: DbPDO
SQL Queries: 570 queries
Time spent querying: 6.537s

Included files: 426
Size of included files: 4.23 Mb

Globals (> 1 Ko only): 983 Ko

 

Doubles (IDs replaced by "XX") (total = 32)

 

Tables stress

 

108 category_lang

 

95 product_attribute_shop

 

95 product_attribute

 

92 category_shop

 

92 category

 

76 product_shop

 

53 product

 

46 category_group

 

39 stock_available

 

Doesn't look good at all...

 

I have tried disabling blocklayered module - no influence. I have also regenerated .htaccess to make sure, no weird redirects are there. I have disabled German language and run the site only with one language, no influence.

 

I talked to the hoster - he says, everything works fine, no problem with hosting.

 

What might be the next steps?

Edited September 29, 2014 by lionna (see edit history)

[El Patron]

bo-->moudles-->positions

 

look for modules hooked to 

displayTop: 4.55s / 5.42 Mb

displayHome: 2.416s / 2.01 Mb

 

this is where much of your page build time is happening.

 

you could try disabling modules in those hooks one by one, check what if any response

 

especially look for 'other' modules in those positions that you may have installed.

 

good news block layered was not problem.

[lionna]

hi El Patron,

thanks! It did a little: I've got less SQL queries. However, the major probem still exists: the timeout at the beginning. You will see it here:

Edited September 29, 2014 by lionna (see edit history)

[mvanrijnen]

Are you running on shared hosting ?

when i put you url in http://www.yougetsignal.com/tools/web-sites-on-web-server/ 

i see 44 domains?

[El Patron]

oops...I missed your original mysql query slow time...my bad...I'm the oldest mod

 

for mysql entries, to find out what is happening, try  also enabling 

 

define('_PS_MODE_DEV_', true);

 

this will set _PS_DEBUG_SQL_ also to true.

 

you then should see the mysql calls for that page

 

again, set both to false when not testing (maint. mode also is a good idea while testing)

[bellini13]

as was already suggested, you should disable the modules in displayTop positions one by one until you find the culprit.  My guess would be a top menu is the issue.  But without seeing the list of modules you are using, its hard to say.

 

So your task would be to review each of the modules in displayTop, I would disable them all and then check the speed and ensure the 3 second delay goes away.

 

Then you can enable them one by one and watch as the time increases.  I would just take this step by step.  First determine if it is a single module causing this 3 second delay, or if it is multiple modules

[lionna]

Hello El Patron and Bellini13,

 

you're fantastic guys. Indeed, this was the menu module that stole 3-4 seconds of the load time. Without it, it'd be 2.5 sec, which is actually still a "shop on toaster", according to PrestaShop. Anyway, there is still some room for performance improvement, and I know much more now on this topic, thanks to my hoster as well.

 

The ropic is solved! Thank you again!