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 /Zotlabs/Module/Hq.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 'Zotlabs/Module/Hq.php')
| -rw-r--r-- | Zotlabs/Module/Hq.php | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/Zotlabs/Module/Hq.php b/Zotlabs/Module/Hq.php index c46695b65..baeba82e8 100644 --- a/Zotlabs/Module/Hq.php +++ b/Zotlabs/Module/Hq.php @@ -51,10 +51,8 @@ class Hq extends \Zotlabs\Web\Controller { $item_normal = item_normal(); $item_normal_update = item_normal_update(); - $use_index = db_use_index('created'); - if(! $item_hash) { - $r = q("SELECT mid FROM item $use_index + $r = q("SELECT mid FROM item WHERE uid = %d $item_normal AND mid = parent_mid ORDER BY created DESC LIMIT 1", |