giuliopowa Posted June 19, 2015 Share Posted June 19, 2015 (edited) hello,my back office is very slow , it run in 4-5 second and sometimes in 10 second.i have ps 1.5.6.1 i have permission 755 in the every folder and 644 in every filethis is page product of my back office ( img 1 - 2 - 3 )if i enable memcache the site run in 20 secondplease help me , do you have any suggestions?? Edited June 30, 2015 by giuliopowa (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted June 19, 2015 Share Posted June 19, 2015 Check the modules hooked to displayBackOfficeHeader, it's taking 4 seconds to process that hook 1 Link to comment Share on other sites More sharing options...
giuliopowa Posted June 19, 2015 Author Share Posted June 19, 2015 thanks for you reply Link to comment Share on other sites More sharing options...
El Patron Posted June 19, 2015 Share Posted June 19, 2015 thanks for you reply you can try disable one of the module 'one' at a time to see if problem goes away, i.e. isolate to module. Link to comment Share on other sites More sharing options...
giuliopowa Posted June 22, 2015 Author Share Posted June 22, 2015 sometimes the module " m4pdf " slows the site , but sometimes.but the problem is when i save or delete the product , the server respond in 0,5 second , but i have to wait about 20 second. Link to comment Share on other sites More sharing options...
giuliopowa Posted June 22, 2015 Author Share Posted June 22, 2015 for example this, if i disable module m4pdf the site run in 1 second Link to comment Share on other sites More sharing options...
giuliopowa Posted June 22, 2015 Author Share Posted June 22, 2015 (edited) ( i have disable module m4pdf )i think the problemi is here DB type: DbPDO SQL Queries: 81 queries Time spent querying: 1.92s Edited June 22, 2015 by giuliopowa (see edit history) Link to comment Share on other sites More sharing options...
tuk66 Posted June 22, 2015 Share Posted June 22, 2015 Sure, it runs faster after disabling the module when just 2 UPDATE queries take almost 6 s. The question is, why 2 UPDATE queries take 6 s instead of 2 ms, as on my server. Link to comment Share on other sites More sharing options...
giuliopowa Posted June 22, 2015 Author Share Posted June 22, 2015 I do not know why i reply you message:( Contact your server administrator and ask why the UPDATE queries take so long. It isn't normal. It seems something is wrong with the database server or maybe the ps_configuration table needs optimization. I did the same test locally and both UPDATE queries in the ps_configuration table took 1ms. ) to my hosting and he reply this:We have performed a MySQL OPTIMIZE_TABLE operation on ps_configuration, and the status is reported as OK. Link to comment Share on other sites More sharing options...
giuliopowa Posted June 22, 2015 Author Share Posted June 22, 2015 but the problem persist also your module is disable, for example now my back office respond in 4-5 second Link to comment Share on other sites More sharing options...
giuliopowa Posted June 22, 2015 Author Share Posted June 22, 2015 this is without module m4pdf , in front office run in 25 second !! Link to comment Share on other sites More sharing options...
tuk66 Posted June 22, 2015 Share Posted June 22, 2015 Your database has a serious problem. Really, ask your administrator or move away. I have seen that many times. Some administrators just don't care or don't know what to do. See the first query. A simple SELECT which returns 1 record and takes almost 12 s. Incredible! Link to comment Share on other sites More sharing options...
giuliopowa Posted June 22, 2015 Author Share Posted June 22, 2015 I saw and I realized that the problem is not with your module, but with the serveri am with a2hosting Power+ Managed VPS https://www.a2hosting.com/managed-vps-hostings Link to comment Share on other sites More sharing options...
giuliopowa Posted June 22, 2015 Author Share Posted June 22, 2015 but if i enable you module this is the debug: Stopwatch (with SQL_NO_CACHE) (total = 89)8219.358 ms UPDATE `ps_configuration` SET `value` = '0',`date_upd` = '2015-06-22 16:46:09' WHERE `name` = 'M4PDF_FILE_ORDERRETURN_FORMAT' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1in /home/etkslo/public_html/classes/Configuration.php:329 4869.306 ms UPDATE `ps_configuration` SET `value` = '1',`date_upd` = '2015-06-22 16:46:02' WHERE `name` = 'M4PDF_LIBRARY' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1in /home/etkslo/public_html/classes/Configuration.php:329 4077.043 ms SELECT SQL_NO_CACHE t.`class_name`, t.`module` FROM `ps_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != ""in /home/etkslo/public_html/classes/Tab.php:222101 rows browsed 2210.911 ms SELECT SQL_NO_CACHE COUNT(*) FROM `ps_hook_module` hm LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'actionPDFInvoiceRender' AND hm.`id_module` = 214 LIMIT 1in /home/etkslo/public_html/classes/module/Module.php:16513 rows browsed 261.899 ms 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)in /home/etkslo/public_html/classes/Configuration.php:116944 rows browsedI do not understand anything anymore Link to comment Share on other sites More sharing options...
giuliopowa Posted June 24, 2015 Author Share Posted June 24, 2015 i think the problem is on " time to first byte " Link to comment Share on other sites More sharing options...
creative7 Posted June 30, 2015 Share Posted June 30, 2015 i have exactly the same problem, a resolution would be great if anyone has any information Link to comment Share on other sites More sharing options...
giuliopowa Posted June 30, 2015 Author Share Posted June 30, 2015 now i solved but the problem It was in server, try to contact your hosting 1 Link to comment Share on other sites More sharing options...
wzzly Posted May 10, 2021 Share Posted May 10, 2021 @giuliopowa Could you share the solution with the server? Have the same problem... 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