bkessler91 Posted December 11, 2013 Share Posted December 11, 2013 My servers have been going slow when I make an updated to inventory. I do this: Log into admin (fast) Search a product I need to update (fast) Enter into the edit screen of that product (fast) Change the qty from 4 to 3 (because I sold one unit in-store) and click Save (its painfully slow once I click Save) I was given the suggestion that I should Optimize the MySQL database via phpMyAdmin. I know how to Optimize, just seeing if I should do all tables in the database, leave some out, or is it not wise to Optimize at all. Thanks My servers have been going slow when I make an updated to inventory. I do this: Log into admin (fast) Search a product I need to update (fast) Enter into the edit screen of that product (fast) Change the qty from 4 to 3 (because I sold one unit in-store) and click Save (its painfully slow once I click Save) I was given the suggestion that I should Optimize the MySQL database via phpMyAdmin. I know how to Optimize, just seeing if I should do all tables in the database, leave some out, or is it not wise to Optimize at all. Thanks or use the "Repair" option? Quote Link to comment Share on other sites More sharing options...
bkessler91 Posted December 12, 2013 Author Share Posted December 12, 2013 I backed up the mySQL databases, and then choose to Optimize. This fixed the lagging. I hope this helps someone. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted December 12, 2013 Share Posted December 12, 2013 Glad that's fixed! I Optimize mine from time to time, but didn't feel comfortable telling you to do it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.