PDA

View Full Version : optimizing db overhead



XtrEM3
01-29-2005, 01:58 PM
i hav a db with almost 1mb of overhead

doesn't that slow down my requests?

how would i go about reducing that

Thanks

Chris
01-29-2005, 04:46 PM
I think the syntax is just "OPTIMIZE TABLE"

AndyH
01-29-2005, 05:39 PM
You would probably have phpMyAdmin.

Go to it, select "Check Overhead" at the bottom of the table list then from the menu just to the right select Optimize.