kannu777 Posted July 19, 2014 Share Posted July 19, 2014 Hello, the prestashop 1.6 site is loading very slow in general, and the following page is specially loading extremely slow. The page can be viewed at the following link http://tinyurl.com/n4d8xo2 I have "smart cache for css" enabled. "Minify Html" enabled "Apache optimization" enabled "compress inline javascript in html" disabled as otherwise the page javascript does not work "smart cache for Javascript " disabled Use Cache" disabled The above are the main settings. The page is very slow, eventhough there are only about 700 products and less than 20 category. When I asked the hosting company, to see if it is a hosting related issue, they say that inefficent mysql query is causing the problem, but i am not technical savvy to know if this is really the case, or if they are just finding any excuse. When reading other post, i saw that i should set ps_debug_profiling to true and see what it shows. It is showing the following, but as i am not technical, it makes no sense to me. Can you please look at below and let me know where the issue might be. thanks Load time: 32.579sYou'd better run your shop on a toasterconfig: 121ms constructor: 0ms init: 58ms checkAccess: 0ms setMedia: 5ms postProcess: 0ms initHeader: 0ms initContent: 32.018s initFooter: 14ms display: 362ms Hook processing: 32.008s / 16.96 Mb66 methods called in 39 modulesactionProductListOverride: 31.36s / 6.89 Mb displayHeader: 553ms / 7.36 Mb displayLeftColumn: 54ms / 0.89 Mb displayTop: 21ms / 1.18 Mb displayFooter: 14ms / 0.46 Mb displayNav: 5ms / 0.14 Mb displayBanner: 1ms / 0.04 Mb displayTopColumn: 0ms / 0 Mb moduleRoutes: 0ms / 0 Mb DisplayOverrideTemplate: 0ms / 0 Mb actionProductListModifier: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb displayProductListFunctionalButtons: 0ms / 0 Mb displayProductListReviews: 0ms / 0 Mb actionFrontControllerSetMedia: 0ms / 0 Mb Memory peak usage: 31.8 Mbconfig: 6.66 Mb (6.8 Mb) constructor: 0 Mb (6.8 Mb) init: 3.92 Mb (10.7 Mb) checkAccess: 0 Mb (10.7 Mb) setMedia: 0.32 Mb (11 Mb) postProcess: 0 Mb (11 Mb) initHeader: 0.01 Mb (11 Mb) initContent: 17.12 Mb (28.2 Mb) initFooter: 0.48 Mb (28.7 Mb) display: 2.17 Mb (31.8 Mb) Total cache size (in Cache class): 0 Mb DB type: DbPDO SQL Queries: 489 queries Time spent querying: 31.515s Included files: 210Size of included files: 2.67 Mb Globals (> 1 Ko only): 365 Kocontext ≈ 163 Ko _LANG ≈ 97.5 Ko _MODULES ≈ 77.9 Ko _SERVER ≈ 9.3 Ko _ENV ≈ 8.4 Ko _MODULE ≈ 1.5 Ko _REQUEST ≈ 1.5 Ko _COOKIE ≈ 1.5 Ko Link to comment Share on other sites More sharing options...
nekgbm Posted July 19, 2014 Share Posted July 19, 2014 Which host are you using ? It could very well be an issue with your hosting provider. Also try using gzip compression and optimize/repair your database to see if that makes a difference. Cheers Link to comment Share on other sites More sharing options...
El Patron Posted July 19, 2014 Share Posted July 19, 2014 actionProductListOverride check back office-->modules-->positions what is hooked there? block layered? there is an apparent issue with block layered. disable it and see how page loads then. note the link you provided does not work. http://screencast.com/t/04jT7T5KrtB Link to comment Share on other sites More sharing options...
kannu777 Posted July 19, 2014 Author Share Posted July 19, 2014 Hello thanks for reply. I have hostgator shared hosting. I have other site with same hosting which is working well, just this site is slow. i have optimized mysql database but it made no difference in loading time. thanks Link to comment Share on other sites More sharing options...
kannu777 Posted July 19, 2014 Author Share Posted July 19, 2014 Hi thanks for the reply. Layered Navigation seems to be the problem. I disabled it, and tried to load the page, it is loading within 2 seconds, but if enabled, it is slowing everything. However i need layered navigation module. Or in your experience as this module is giving a problem, is there any other that we can use with same functions thanks 1 Link to comment Share on other sites More sharing options...
El Patron Posted July 20, 2014 Share Posted July 20, 2014 This is a difficult issue you have and I do not have the block layered experience. I understand you need this and when no issues is a great feature. It will be useful to community if we know exact 1.6 version and your block layered module version. If after knowing versions and now 'searchable' solution is found then open a forge report: http://forge.prestashop.com/secure/Dashboard.jspa post the url back here for others to follow/comment/vote up. also further down in the report (screen shot above) you should see the sql executed, please include here and on forge. Link to comment Share on other sites More sharing options...
bellini13 Posted July 20, 2014 Share Posted July 20, 2014 your host said there is an ineffective SQL query running, then they should be able to say what the query is. i would suggest asking them for that query, and then we have something to discuss Link to comment Share on other sites More sharing options...
Recommended Posts