Slow Load Speed

[meccabooks]

I just uploaded to 1.6 from 1.5, I did a clean install of 1.6 and transferred the database over to new server. currently just testing the website, however it is pretty slow. I see there are few main bottle necks. Please review and let me know the best solutions, separated out below. 

 

 

displayTop

58.41 Mb in 2278 ms

displayHeader

15.92 Mb in 244 ms

 

Execution

Memory (Mb)

Total (Mb)

config

19.45

19.5

initContent

79.55

107.9

 

 

DB type: DbPDO

SQL Queries: 3577 queries

Time spent querying: 738 ms

 

 

 

 

Load time: 3446 ms
You'd better run your shop on a toaster

Execution Load time (ms) config 288 constructor 0 init 107 checkAccess 0 setMedia 8 postProcess 0 initHeader 0 initContent 2682 initFooter 17 display 345

Hook processing: 2699 ms / 82.33 Mb
156 methods called in 52 modules

Hook Processing displayTop 58.41 Mb in 2278 ms displayHeader 15.92 Mb in 244 ms displayFooterTop 2.20 Mb in 34 ms moduleRoutes 2.96 Mb in 30 ms displayProductTabContent 0.29 Mb in 25 ms displayFooterProduct 0.21 Mb in 16 ms displayFooter 0.58 Mb in 16 ms displayProductSecondaryColumn 0.56 Mb in 12 ms displayProductTab 0.16 Mb in 12 ms displayTopLeft 0.64 Mb in 8 ms displayTopSecondary 0.18 Mb in 6 ms displayFooterSecondary 0.06 Mb in 4 ms displayNav 0.06 Mb in 3 ms displayRightColumnProduct 0.03 Mb in 3 ms displayAnywhere 0.03 Mb in 2 ms displayLeftColumnProduct 0.02 Mb in 2 ms displayProductButtons 0.02 Mb in 2 ms actionProductOutOfStock 0.00 Mb in 0 ms actionFrontControllerSetMedia 0.00 Mb in 0 ms displayProductPriceBlock 0.00 Mb in 0 ms actionDispatcher 0.00 Mb in 0 ms displayProductContent 0.00 Mb in 0 ms displayBanner 0.00 Mb in 0 ms displayTopColumn 0.00 Mb in 0 ms displayProductDeliveryTime 0.00 Mb in 0 ms DisplayOverrideTemplate 0.00 Mb in 0 ms

Memory peak usage: 111.7 Mb

Execution Memory (Mb) Total (Mb) config 19.45 19.5 constructor 0.00 19.5 init 8.43 28.1 checkAccess 0.00 28.1 setMedia 0.34 28.4 postProcess 0.00 28.4 initHeader 0.01 28.4 initContent 79.55 107.9 initFooter 0.61 108.6 display 2.71 111.7

Total cache size (in Cache class): 0.00 Mb

DB type: DbPDO

SQL Queries: 3577 queries

Time spent querying: 738 ms

Included files: 218

Size of included files: 5.06 Mb

Globals (> 1 Ko only): 227 Ko

• _LANG ≈ 98.4 Ko
• _MODULES ≈ 95.9 Ko
• HTTP_SERVER_VARS ≈ 8.3 Ko
• _SERVER ≈ 8.3 Ko
• _MODULE ≈ 3.7 Ko
• _ENV ≈ 1.7 Ko
• HTTP_ENV_VARS ≈ 1.7 Ko
• _REQUEST ≈ 1.4 Ko
• HTTP_COOKIE_VARS ≈ 1.4 Ko
• _COOKIE ≈ 1.4 Ko

•  

 

[JPresta.com]

Which modules do you have in displayTop?

[meccabooks]

I have below modules in Display Top

 

1. Quick Search Block
2. User Info Block
3. Cart block
4. Pages not found

[meccabooks]

if this helps...

 

 

SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop

FROM `ps_configuration` c

LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)

6.518

1593

 

 

in /public_html/classes/Configuration.php:134

 

from /config/config.inc.php:116

from /index.php:27

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`

FROM `ps_module` m

INNER JOIN ps_module_shop module_shop

ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)

INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`

INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`

INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`

LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`

WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))

GROUP BY hm.id_hook, hm.id_module

ORDER BY hm.`position`

4.696

517

Yes

Yes

in /public_html/classes/Hook.php:346

 

from /tools/profiling/Hook.php:50

from /classes/Dispatcher.php:413

from /classes/Dispatcher.php:230

from /classes/Dispatcher.php:193

from /index.php:28

[PrestaHeroes USA]

back office-->advanced parms-->performance

 

 

here are my suggested settings

 

http://screencast.com/t/W41rbKo4