meccabooks Posted November 25, 2014 Share Posted November 25, 2014 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 msYou'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 Mb156 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 Link to comment Share on other sites More sharing options...
JPresta.com Posted November 25, 2014 Share Posted November 25, 2014 Which modules do you have in displayTop? Link to comment Share on other sites More sharing options...
meccabooks Posted November 25, 2014 Author Share Posted November 25, 2014 I have below modules in Display Top Quick Search Block User Info Block Cart block Pages not found Link to comment Share on other sites More sharing options...
meccabooks Posted November 25, 2014 Author Share Posted November 25, 2014 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 Link to comment Share on other sites More sharing options...
El Patron Posted November 25, 2014 Share Posted November 25, 2014 back office-->advanced parms-->performance here are my suggested settings http://screencast.com/t/W41rbKo4 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now