PHP CHOQ_DB_Mysql::query Examples

Example #1

File: Mysql.class.php Project: nonconforme/nreeda

 /**
  * Optimize all existing tables
  * Warning: This does only work for  MyISAM-, BDB- and InnoDB tables
  */
 public function optimizeTables()
 {
     $tables = $this->getExistingTables();
     foreach ($tables as $table => $tableLower) {
         $this->db->query("OPTIMIZE TABLE `{$table}`");
     }
 }