rgwhitaker Posted August 25, 2014 Share Posted August 25, 2014 During the weekend I upgraded to PS 1.5.6.2 from 1.5.4.1. Though the BO was slow before, it's still WAY slow now to the point of being useless. In the config/defines.inc.php file, I changed the following: define('_PS_DEBUG_PROFILING_', false); to define('_PS_DEBUG_PROFILING_', true); Here's the results when I go into BO, then click Catalog > Products. Is there something else within the report I should be looking for? Load time: 30.056sYou'd better run your shop on a toasterconfig: 8.011s constructor: 0ms init: 96ms checkAccess: 0ms setMedia: 1ms postProcess: 0ms initHeader: 8ms initContent: 21.92s initFooter: 0ms display: 20ms Hook processing: 82ms / 3.68 MbdisplayBackOfficeHeader: 66ms / 3.42 Mb moduleRoutes: 15ms / 0.25 Mb displayAdminListAfter: 0ms / 0 Mb displayBackOfficeFooter: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb displayBackOfficeTop: 0ms / 0 Mb displayAdminListBefore: 0ms / 0 Mb actionAdminControllerSetMedia: 0ms / 0 Mb displayAdminProductsListAfter: 0ms / 0 Mb displayAdminProductsListBefore: 0ms / 0 Mb Memory peak usage: 38 Mb config: 13.33 Mb (15.5 Mb) constructor: 0 Mb (15.5 Mb) init: 5.13 Mb (18.8 Mb) checkAccess: 0 Mb (18.8 Mb) setMedia: 0 Mb (18.8 Mb) postProcess: 0 Mb (18.8 Mb) initHeader: 0.52 Mb (19.2 Mb) initContent: 16.75 Mb (36.3 Mb) initFooter: 0.01 Mb (36.3 Mb) display: 0.77 Mb (38 Mb) DB type: DbPDOSQL Queries: 670 queriesTime spent querying: 29.361s Link to comment Share on other sites More sharing options...
Bojo2 Posted August 25, 2014 Share Posted August 25, 2014 What are the details of the server you're running ps on? Link to comment Share on other sites More sharing options...
rgwhitaker Posted August 25, 2014 Author Share Posted August 25, 2014 How can I get those details? Link to comment Share on other sites More sharing options...
El Patron Posted August 25, 2014 Share Posted August 25, 2014 http://www.prestashop.com/forums/topic/224525-how-to-turn-on-error-reporting-for-debug-information/ then re-visit slow pages... see if any error Link to comment Share on other sites More sharing options...
rgwhitaker Posted August 25, 2014 Author Share Posted August 25, 2014 I will do that and post here. Thank you. 1 Link to comment Share on other sites More sharing options...
rgwhitaker Posted August 25, 2014 Author Share Posted August 25, 2014 I followed the steps. Where do the errors appear? Link to comment Share on other sites More sharing options...
El Patron Posted August 25, 2014 Share Posted August 25, 2014 I followed the steps. Where do the errors appear? if any errors (then they would appear on the page having issue)...you are looking for additional information, maybe no error is happening hence no error message. your mysql queries is issue but why I do not know. Link to comment Share on other sites More sharing options...
rgwhitaker Posted August 25, 2014 Author Share Posted August 25, 2014 I logged into my cPanel and looked at the Error Log report. There were no errors listed. Link to comment Share on other sites More sharing options...
El Patron Posted August 25, 2014 Share Posted August 25, 2014 make sure your back office settings look like this: http://screencast.com/t/QCLrXFDd7 Link to comment Share on other sites More sharing options...
rgwhitaker Posted August 25, 2014 Author Share Posted August 25, 2014 Would your BOZoom module help in this case? Link to comment Share on other sites More sharing options...
El Patron Posted August 25, 2014 Share Posted August 25, 2014 Would your BOZoom module help in this case? 29+ seconds doing mysql calls, no module will fix. Link to comment Share on other sites More sharing options...
El Patron Posted August 25, 2014 Share Posted August 25, 2014 because you did upgrade, and suppose fallback to previous version is not an option. Consider posting in 'job offers', many with very experience finding paid trouble shooters at very fair rates. Link to comment Share on other sites More sharing options...
rgwhitaker Posted August 25, 2014 Author Share Posted August 25, 2014 Yes. My Smart Cache section within Performance looks like that. I have a button next to Cache that reads: "Clear Smart cache & Autoload cache." Should I click that to clear Smarty Cache? Link to comment Share on other sites More sharing options...
El Patron Posted August 25, 2014 Share Posted August 25, 2014 Yes. My Smart Cache section within Performance looks like that. I have a button next to Cache that reads: "Clear Smart cache & Autoload cache." Should I click that to clear Smarty Cache? yes, please do. Link to comment Share on other sites More sharing options...
rgwhitaker Posted August 25, 2014 Author Share Posted August 25, 2014 Perhaps I'll have to do that. Thank you for your assistance. For job offers, do you have any recommendations from this board? 1 Link to comment Share on other sites More sharing options...
rgwhitaker Posted August 25, 2014 Author Share Posted August 25, 2014 I clicked that button. How long should it take? It's still going. Link to comment Share on other sites More sharing options...
El Patron Posted August 25, 2014 Share Posted August 25, 2014 Perhaps I'll have to do that. Thank you for your assistance. For job offers, do you have any recommendations from this board? I would only use community member who follows forum rules and helps in the general community. http://www.prestashop.com/forums/topic/337480-read-before-posting-job-offer-responses/ Link to comment Share on other sites More sharing options...
El Patron Posted August 25, 2014 Share Posted August 25, 2014 I clicked that button. How long should it take? It's still going. thanks for the update...let us know when it finishes, make sure to turn off profiling when not being used...this displays for any visitor front or back and can slow things down more, make sure to keep your info. this is also true when errors (debug) is enabled so make sure to turn off when done testing. Link to comment Share on other sites More sharing options...
rgwhitaker Posted August 25, 2014 Author Share Posted August 25, 2014 What's profiling? Link to comment Share on other sites More sharing options...
El Patron Posted August 25, 2014 Share Posted August 25, 2014 During the weekend I upgraded to PS 1.5.6.2 from 1.5.4.1. Though the BO was slow before, it's still WAY slow now to the point of being useless. In the config/defines.inc.php file, I changed the following: define('_PS_DEBUG_PROFILING_', false); to define('_PS_DEBUG_PROFILING_', true); Here's the results when I go into BO, then click Catalog > Products. Is there something else within the report I should be looking for? Load time: 30.056sYou'd better run your shop on a toaster config: 8.011s constructor: 0ms init: 96ms checkAccess: 0ms setMedia: 1ms postProcess: 0ms initHeader: 8ms initContent: 21.92s initFooter: 0ms display: 20ms Hook processing: 82ms / 3.68 MbdisplayBackOfficeHeader: 66ms / 3.42 Mb moduleRoutes: 15ms / 0.25 Mb displayAdminListAfter: 0ms / 0 Mb displayBackOfficeFooter: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb displayBackOfficeTop: 0ms / 0 Mb displayAdminListBefore: 0ms / 0 Mb actionAdminControllerSetMedia: 0ms / 0 Mb displayAdminProductsListAfter: 0ms / 0 Mb displayAdminProductsListBefore: 0ms / 0 Mb Memory peak usage: 38 Mb config: 13.33 Mb (15.5 Mb) constructor: 0 Mb (15.5 Mb) init: 5.13 Mb (18.8 Mb) checkAccess: 0 Mb (18.8 Mb) setMedia: 0 Mb (18.8 Mb) postProcess: 0 Mb (18.8 Mb) initHeader: 0.52 Mb (19.2 Mb) initContent: 16.75 Mb (36.3 Mb) initFooter: 0.01 Mb (36.3 Mb) display: 0.77 Mb (38 Mb) DB type: DbPDOSQL Queries: 670 queries Time spent querying: 29.361s What's profiling? what you did in your original post. Link to comment Share on other sites More sharing options...
rgwhitaker Posted August 26, 2014 Author Share Posted August 26, 2014 Oh. Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts