JODY44

Hi, EL Patron and everyone, heres an update for my problem. On debug mode I cannot change setting, every time I tried to change it went back to the same setting. disable non-prestashop modules (no) and disable all overrides (yes) what this indicate to the problem ? After getting the ISP to change SQL servers, my website seems to work fine now and has not suffered from the awful slowness, and hopefully it will stay that way. For layered navigation enabled I have some enabled and some disabled but I think that my main problem is sql server and it happened sometime without me making any changes to the settings. However, I still feel that something is not quite right I recently purchased a popup module from an external developer and have problem where the Popup opens on every page, even if I been and visited that page once, if I go back to that page the popup opens again. I thought their module had a problem. However, I have just bought another popup Box Notification (Popup) developed by PrestaShop and it has the same problem. I contacted prestashop, but did not hear from them yet. Did anyone have the same problem ?

HI Ei Patron Here is the result, you think this is from SQL or PS also My host will move sql server for me tonight but I’m not sure if is from SQL alone that cause problem Load time: 46.878s You'd better run your shop on a toaster config: 10.881s constructor: 0ms init: 35.205s checkAccess: 0ms setMedia: 6ms postProcess: 0ms initHeader: 0ms initContent: 513ms initFooter: 94ms display: 179ms Hook processing: 35.753s / 10.72 Mb 57 methods called in 35 modulesactionCartSave: 35.053s / 1.23 Mb displayHome: 332ms / 0.31 Mb displayHeader: 140ms / 7.05 Mb displayFooter: 94ms / 0.57 Mb displayTopColumn: 88ms / 0.08 Mb displayTop: 40ms / 1.34 Mb displayNav: 4ms / 0.1 Mb displayBanner: 2ms / 0.03 Mb moduleRoutes: 0ms / 0 Mb actionFrontControllerSetMedia: 0ms / 0 Mb displayHomeTab: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb displayHomeTabContent: 0ms / 0 Mb DisplayOverrideTemplate: 0ms / 0 Mb actionObjectUpdateBefore: 0ms / 0 Mb actionObjectUpdateAfter: 0ms / 0 Mb actionObjectCartUpdateBefore: 0ms / 0 Mb actionObjectCartUpdateAfter: 0ms / 0 Mb Memory peak usage: 22.4 Mbconfig: 6.77 Mb (6.9 Mb) constructor: 0 Mb (6.9 Mb) init: 5.14 Mb (12.1 Mb) checkAccess: 0 Mb (12.1 Mb) setMedia: 0.21 Mb (12.3 Mb) postProcess: 0 Mb (12.3 Mb) initHeader: 0.01 Mb (12.3 Mb) initContent: 8.72 Mb (21.2 Mb) initFooter: 0.59 Mb (22 Mb) display: 0.52 Mb (22.4 Mb) Total cache size (in Cache class): 0.75 Mb DB type: DbPDO SQL Queries: 13 queries Time spent querying: 46.396s Included files: 207 Size of included files: 2.6 Mb Globals (> 1 Ko only): 591 Ko_MODULES ≈ 304.6 Ko _LANG ≈ 184.1 Ko context ≈ 71.5 Ko _SERVER ≈ 10.3 Ko _ENV ≈ 10 Ko _MODULE ≈ 3.7 Ko _REQUEST ≈ 1.4 Ko _COOKIE ≈ 1.4 Ko Go to Stopwatch Go to Doubles Go to Tables Go to ObjectModels Display queries table Go to files Time (ms) Rows Query Location Filesort Group By 35016.712 1702 SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1) /classes/module/Module.php:1717 10765.613 585 SELECT 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`) /classes/Configuration.php:118 313.094 21 SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'home' AND active = 1 ORDER BY item_order ASC /modules/themeconfigurator/themeconfigurator.php:330 Yes 80.435 21 SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'top' AND active = 1 ORDER BY item_order ASC /modules/themeconfigurator/themeconfigurator.php:330 Yes 36.915 1 SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta WHERE ( m.page = "index" OR m.page = "index" ) AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1 /classes/Meta.php:142 29.449 1 INSERT IGNORE INTO `ps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('12255', '1', '2014-05-30 13:50:46') /classes/Connection.php:101 26.644 1 SELECT value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1 /classes/cache/CacheFs.php:36 22.479 0 SELECT * FROM `ps_cart` a WHERE (a.id_cart = 169) LIMIT 1 /classes/ObjectModel.php:212 22.333 0 SELECT `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name /classes/Hook.php:131 22.015 1 SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme) LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta) WHERE t.id_theme =1 AND m.page = "index" LIMIT 1 /classes/Theme.php:177 21.876 1 SELECT `id_page` FROM `ps_page` WHERE `id_page_type` = 1 LIMIT 1 /classes/Page.php:78 19.664 1 UPDATE `ps_cart` SET `id_shop_group` = '0',`id_shop` = '0',`id_address_delivery` = '0',`id_address_invoice` = '0',`id_carrier` = '0',`id_currency` = '1',`id_customer` = '0',`id_guest` = '0',`id_lang` = '1',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`delivery_option` = '',`secure_key` = '',`allow_seperated_package` = '0',`date_add` = '0000-00-00',`date_upd` = '2014-05-30 13:50:10' WHERE `id_cart` = 0 /classes/ObjectModel.php:596 18.487 1 SELECT id_page_type FROM ps_page_type WHERE name = 'index' LIMIT 1 /classes/Page.php:96 Stopwatch (with SQL_NO_CACHE) (total = 13) 35016.712 ms SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1) in /classes/module/Module.php:1717 from /classes/Hook.php:469 from /tools/profiling/Hook.php:60 from /classes/Cart.php:200 from /classes/controller/FrontController.php:215 from /tools/profiling/Controller.php:195 from /classes/Dispatcher.php:373 from /index.php:28 1702 rows browsed 10765.613 ms SELECT 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`) in /classes/Configuration.php:118 from /config/config.inc.php:113 from /index.php:27 585 rows browsed 313.094 ms SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'home' AND active = 1 ORDER BY item_order ASC in /modules/themeconfigurator/themeconfigurator.php:330 from /modules/themeconfigurator/themeconfigurator.php:252 from /classes/Hook.php:507 from /tools/profiling/Hook.php:60 from /controllers/front/IndexController.php:40 from /tools/profiling/Controller.php:227 from /classes/Dispatcher.php:373 from /index.php:28 USING FILESORT - 21 rows browsed 80.435 ms SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'top' AND active = 1 ORDER BY item_order ASC in /modules/themeconfigurator/themeconfigurator.php:330 from /modules/themeconfigurator/themeconfigurator.php:242 from /modules/themeconfigurator/themeconfigurator.php:234 from /classes/Hook.php:507 from /tools/profiling/Hook.php:60 from /config/smarty.config.inc.php:188 from :undefined from /config/smarty.config.inc.php:241 from /cache/smarty/compile/c1/03/58/c103587743800001c5bb6488d2abbb37927b68b5.file.header.tpl.php:169 from /cache/smarty/compile/c1/03/58/c103587743800001c5bb6488d2abbb37927b68b5.file.header.tpl.php:169 from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180 from /tools/smarty/sysplugins/smarty_internal_template.php:286 from /cache/smarty/compile/97/4f/a0/974fa04aa59f01f524e1f81e6c4fd97b63cfaa98.file.layout.tpl.php:38 from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180 from /classes/controller/Controller.php:402 from /classes/controller/FrontController.php:562 from /tools/profiling/Controller.php:299 from /tools/profiling/Controller.php:249 from /classes/Dispatcher.php:373 from /index.php:28 USING FILESORT - 21 rows browsed 36.915 ms SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta WHERE ( m.page = "index" OR m.page = "index" ) AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1 in /classes/Meta.php:142 from /classes/Meta.php:225 from /classes/Meta.php:212 from /classes/controller/FrontController.php:286 from /tools/profiling/Controller.php:195 from /classes/Dispatcher.php:373 from /index.php:28 1 row browsed 29.449 ms INSERT IGNORE INTO `ps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('12255', '1', '2014-05-30 13:50:46') in /classes/Connection.php:101 from /modules/statsdata/statsdata.php:104 from /classes/Hook.php:509 from /tools/profiling/Hook.php:60 from /classes/controller/FrontController.php:808 from /tools/profiling/Controller.php:233 from /classes/Dispatcher.php:373 from /index.php:28 26.644 ms SELECT value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1 in /classes/cache/CacheFs.php:36 from /classes/cache/Cache.php:131 from /classes/db/Db.php:495 from /classes/shop/Shop.php:329 from /config/config.inc.php:94 from /index.php:27 1 row browsed 22.479 ms SELECT * FROM `ps_cart` a WHERE (a.id_cart = 169) LIMIT 1 in /classes/ObjectModel.php:212 from /tools/profiling/ObjectModel.php:37 from /classes/Cart.php:155 from /classes/controller/FrontController.php:195 from /tools/profiling/Controller.php:195 from /classes/Dispatcher.php:373 from /index.php:28 0 rows browsed 22.333 ms SELECT `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name in /classes/Hook.php:131 from /classes/Hook.php:417 from /tools/profiling/Hook.php:60 from /classes/Cart.php:200 from /classes/controller/FrontController.php:215 from /tools/profiling/Controller.php:195 from /classes/Dispatcher.php:373 from /index.php:28 0 rows browsed 22.015 ms SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme) LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta) WHERE t.id_theme =1 AND m.page = "index" LIMIT 1 in /classes/Theme.php:177 from /classes/controller/FrontController.php:78 from /classes/controller/Controller.php:135 from /classes/Dispatcher.php:366 from /index.php:28 1 row browsed 21.876 ms SELECT `id_page` FROM `ps_page` WHERE `id_page_type` = 1 LIMIT 1 in /classes/Page.php:78 from /classes/Connection.php:90 from /modules/statsdata/statsdata.php:104 from /classes/Hook.php:509 from /tools/profiling/Hook.php:60 from /classes/controller/FrontController.php:808 from /tools/profiling/Controller.php:233 from /classes/Dispatcher.php:373 from /index.php:28 1 row browsed 19.664 ms UPDATE `ps_cart` SET `id_shop_group` = '0',`id_shop` = '0',`id_address_delivery` = '0',`id_address_invoice` = '0',`id_carrier` = '0',`id_currency` = '1',`id_customer` = '0',`id_guest` = '0',`id_lang` = '1',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`delivery_option` = '',`secure_key` = '',`allow_seperated_package` = '0',`date_add` = '0000-00-00',`date_upd` = '2014-05-30 13:50:10' WHERE `id_cart` = 0 in /classes/ObjectModel.php:596 from /classes/Cart.php:199 from /classes/controller/FrontController.php:215 from /tools/profiling/Controller.php:195 from /classes/Dispatcher.php:373 from /index.php:28 19.664 ms UPDATE `ps_cart` SET `id_shop_group` = '0',`id_shop` = '0',`id_address_delivery` = '0',`id_address_invoice` = '0',`id_carrier` = '0',`id_currency` = '1',`id_customer` = '0',`id_guest` = '0',`id_lang` = '1',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`delivery_option` = '',`secure_key` = '',`allow_seperated_package` = '0',`date_add` = '0000-00-00',`date_upd` = '2014-05-30 13:50:10' WHERE `id_cart` = 0 in /classes/ObjectModel.php:596

ok they are in this /config/defines.inc.php so could anyone suggest if this is problem from prestashop on server Sorry I'm not a technical person and need help. Load time: 47.132s You'd better run your shop on a toaster config: 11.003s constructor: 0ms init: 34.936s checkAccess: 0ms setMedia: 4ms postProcess: 0ms initHeader: 0ms initContent: 764ms initFooter: 146ms display: 279ms Hook processing: 35.862s / 10.67 Mb 57 methods called in 35 modules actionCartSave: 34.762s / 1.23 Mb displayHeader: 670ms / 7.04 Mb displayTopColumn: 173ms / 0.06 Mb displayFooter: 146ms / 0.56 Mb displayHome: 68ms / 0.3 Mb displayTop: 26ms / 1.34 Mb displayNav: 15ms / 0.1 Mb displayBanner: 3ms / 0.03 Mb displayHomeTabContent: 0ms / 0 Mb moduleRoutes: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb actionObjectUpdateAfter: 0ms / 0 Mb actionObjectUpdateBefore: 0ms / 0 Mb displayHomeTab: 0ms / 0 Mb actionFrontControllerSetMedia: 0ms / 0 Mb actionObjectCartUpdateAfter: 0ms / 0 Mb DisplayOverrideTemplate: 0ms / 0 Mb actionObjectCartUpdateBefore: 0ms / 0 Mb Memory peak usage: 42.3 Mb config: 10.99 Mb (11.1 Mb) constructor: 0 Mb (11.1 Mb) init: 13.92 Mb (29.2 Mb) checkAccess: 0 Mb (29.2 Mb) setMedia: 0.21 Mb (29.2 Mb) postProcess: 0 Mb (29.2 Mb) initHeader: 0.01 Mb (29.2 Mb) initContent: 8.71 Mb (34.2 Mb) initFooter: 0.57 Mb (42.3 Mb) display: 0.5 Mb (42.3 Mb) Total cache size (in Cache class): 0.75 Mb DB type: DbPDO SQL Queries: 7 queries Time spent querying: 45.503s

Hi, EI Patron it happened again !!! I'm opened config/settings.inc.php but cannot see this (define('_PS_DEBUG_PROFILING) line at all. --removed--

Thank you el-patron, will do that.

Thank you joemartin ! finally, my host has offered to move the DB to another sever for me, if this problem has been caused from the current sever hopefully, It will soon be resolved.

Hi, I use PS V1.6 My website normally is loading in about 3 -4 seconds, but sometimes it takes 55 seconds to load 1 page, and when that happens it is going on for all day, and even so slow that it comes up with gateway errors, and then it goes back to normal Now it has happened again, I try to contact the Hosts but they just said that they cannot see anything wrong with it. Frist time it happened after I switched on web service by mistake. It does not happen straight away, I think after about 24 hours, I switched off that option clear cache, then It's back to normal again But since that, it has happened on and off, sometimes after I installed a module and uninstall it. And sometimes without making any changes to it. I have no idea on how to fix this problem. We did not get any orders at all when this happens so is costing a lot of money. Can anyone please advise.....HELP

Thank you this fixed my problem

I have the same problem also. I did tried upload the JavaScript theme 1.6.0.5 to 1.6.0.6 the price show up but attribute price still not show and not change when select attribute but when added to cart it show prices in cart. and I’m not an expert on scripts, please help ! how to fix this.