diff options
| author | Paul Arthur <paul.arthur@flowerysong.com> | 2013-01-26 00:23:12 -0500 |
|---|---|---|
| committer | Paul Arthur <paul.arthur@flowerysong.com> | 2013-01-26 00:23:12 -0500 |
| commit | fd5b7e1b10c00738f1a27f94c5ee529352dd68ca (patch) | |
| tree | 2ec56c4f940ccfd50754aa5d250a5678c6d8e19e /lib/class/catalog.class.php | |
| parent | 7703c9431d6989af12e9c75a35cf8f641482a81f (diff) | |
| download | ampache-fd5b7e1b10c00738f1a27f94c5ee529352dd68ca.tar.gz ampache-fd5b7e1b10c00738f1a27f94c5ee529352dd68ca.tar.bz2 ampache-fd5b7e1b10c00738f1a27f94c5ee529352dd68ca.zip | |
Move Catalog::optimize_tables() to Dba
Diffstat (limited to 'lib/class/catalog.class.php')
| -rw-r--r-- | lib/class/catalog.class.php | 21 |
1 files changed, 0 insertions, 21 deletions
diff --git a/lib/class/catalog.class.php b/lib/class/catalog.class.php index d5bea0ef..02aa9135 100644 --- a/lib/class/catalog.class.php +++ b/lib/class/catalog.class.php @@ -1526,27 +1526,6 @@ class Catalog extends database_object { } /** - * optimize_tables - * This runs an optimize on the tables and updates the stats to improve - * join speed. - * This can be slow, but is a good idea to do from time to time. We do - * it in case the dba isn't doing it... which we're going to assume they - * aren't - */ - public static function optimize_tables() { - $sql = "SHOW TABLES"; - $db_results = Dba::read($sql); - - while($row = Dba::fetch_row($db_results)) { - $sql = "OPTIMIZE TABLE `" . $row[0] . "`"; - $db_results_inner = Dba::write($sql); - - $sql = "ANALYZE TABLE `" . $row[0] . "`"; - $db_results_inner = Dba::write($sql); - } - } // optimize_tables; - - /** * trim_prefix * Splits the prefix from the string */ |