• 0

[mySQL] Optimizing Tables


Question

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 AshMan
Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.