/** * 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}`"); } }