Optimize MySQL table?

[bkessler91]

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?  

[bkessler91]

I backed up the mySQL databases, and then choose to Optimize.  This fixed the lagging.

 

I hope this helps someone.

[Dirty Butter]

Glad that's fixed! I Optimize mine from time to time, but didn't feel comfortable telling you to do it.