AshMan Posted March 23, 2003 Share Posted March 23, 2003 (edited) How often should I optimize my tables? I was thinking of adding this line to all my PHP pages that write to the DB: $sSQL = "OPTIMIZE TABLE my_table_name"; Is it recommended? Does it speed things up? And is it even needed? I've love to hear your thoughts on this. Thanks. Ash Edited March 23, 2003 by AshMan Link to comment Share on other sites More sharing options...
Question
AshMan
How often should I optimize my tables?
I was thinking of adding this line to all my PHP pages that write to the DB:
$sSQL = "OPTIMIZE TABLE my_table_name";
Is it recommended? Does it speed things up? And is it even needed?
I've love to hear your thoughts on this.
Thanks.
Ash
Edited by AshManLink to comment
Share on other sites
0 answers to this question
Recommended Posts