diff options
| author | Mario Vavti <mario@mariovavti.com> | 2018-02-04 20:42:40 +0100 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2018-02-04 20:42:40 +0100 |
| commit | 3cc756f3029e5f3b02008dac94a90e168d398c9a (patch) | |
| tree | bc6b6cdc552ef119e0f7beb8b40e83ffe59798c7 /install/update.php | |
| parent | 512f3a764361dde44e36fb72c105265d6df298ad (diff) | |
| download | volse-hubzilla-3cc756f3029e5f3b02008dac94a90e168d398c9a.tar.gz volse-hubzilla-3cc756f3029e5f3b02008dac94a90e168d398c9a.tar.bz2 volse-hubzilla-3cc756f3029e5f3b02008dac94a90e168d398c9a.zip | |
remove some never used indices which prevented our item queries to find the right query execution plan in mysql and adjust some queries to optimze the result
Diffstat (limited to 'install/update.php')
| -rw-r--r-- | install/update.php | 19 |
1 files changed, 18 insertions, 1 deletions
diff --git a/install/update.php b/install/update.php index f7b9b03ed..1bb39fc65 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1198 ); +define( 'UPDATE_VERSION' , 1199 ); /** * @@ -3070,3 +3070,20 @@ function update_r1197() { return UPDATE_SUCCESS; } + +function update_r1198() { + + if(ACTIVE_DBTYPE == DBTYPE_MYSQL) { + $r = q("ALTER TABLE item + DROP INDEX item_blocked, + DROP INDEX item_unpublished, + DROP INDEX item_deleted, + DROP INDEX item_delayed, + DROP INDEX item_hidden, + DROP INDEX item_pending_remove, + DROP INDEX item_type + "); + } + + return UPDATE_SUCCESS; +} |