Ottimizzare DataBase

[jaym]

$SQL = "OPTIMIZE TABLE ";
   $result = mysql_list_tables($DATABASE);
   $i = 0;
   while ($i < mysql_num_rows($result)) {
      $name_table = mysql_table_name($result, $i);
      echo "Tabella: $name_table .....
";
      $SQL .=  $name_table;
      $SQL .= ",";
      $i++;
   }
   $SQL = substr($SQL,0,strlen($SQL)-1);
   $qry= mysql_query($SQL);
   mysql_free_result($qry);