diff options
| author | Jams H Thompson <jht001@users.sourceforge.net> | 2005-06-19 10:35:39 +0000 |
|---|---|---|
| committer | Jams H Thompson <jht001@users.sourceforge.net> | 2005-06-19 10:35:39 +0000 |
| commit | e206183dc320e9b6311e63075bbdf67f69d2b1ac (patch) | |
| tree | ba5302bfc234bcbbb88fa467dfebf3e416a03888 /admin | |
| parent | 1d81c8d6d433d225da74d7d0ab33c775395a4c5b (diff) | |
| download | wiki-e206183dc320e9b6311e63075bbdf67f69d2b1ac.tar.gz wiki-e206183dc320e9b6311e63075bbdf67f69d2b1ac.tar.bz2 wiki-e206183dc320e9b6311e63075bbdf67f69d2b1ac.zip | |
add indexes to speed up TikiWiki 1.8 DB conversions
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/upgrade_inc.php | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/admin/upgrade_inc.php b/admin/upgrade_inc.php index 8e22628..1c0bbb9 100644 --- a/admin/upgrade_inc.php +++ b/admin/upgrade_inc.php @@ -12,6 +12,10 @@ array( 'QUERY' => array( 'MYSQL' => array( "ALTER TABLE `".BIT_DB_PREFIX."tiki_history` DROP PRIMARY KEY", "ALTER TABLE `".BIT_DB_PREFIX."tiki_links` DROP PRIMARY KEY", +// jht 2005-06-19_00:05:40 adding the following two indexes significantly speeds up large TikiWiki 1.8 upgrades + "ALTER TABLE ".BIT_DB_PREFIX."tiki_pages ADD INDEX version (version)", + "ALTER TABLE ".BIT_DB_PREFIX."tiki_history ADD INDEX version (version)", + )), ), |