function ARC_api::optimize_tables in Taxonomy import/export via XML 5

Same name and namespace in other branches

1. 5.2 arc/ARC_api.php \ARC_api::optimize_tables()
2. 6.2 arc/ARC_api.php \ARC_api::optimize_tables()
3. 6 arc/ARC_api.php \ARC_api::optimize_tables()

File

arc/ARC_api.php, line 409

Class

ARC_api

Code

function optimize_tables() {
  $prefix = $this->config["prefix"];
  $tmp = mysql_query("FLUSH TABLES");
  $tbls = $this
    ->get_tables();
  $sql = "";
  foreach ($tbls as $cur_tbl) {
    $sql .= strlen($sql) ? ", " : "";
    $sql .= " '" . $prefix . "_" . $cur_tbl . "'";
  }
  return mysql_query("ANALYZE TABLE" . $sql);
}