Details
-
Bug
-
Resolution: Fixed
-
Medium
-
3.8.8, 3.9.2
-
None
Description
When a object is add/change/delete or when you use the updatesearchindex extension the table ezsearch_* are update
In the plugins file ezsearchengine.php line 417 the query
"DELETE FROM ezsearch_word WHERE object_count='0'" is faster if we add the index
ALTER table ezsearch_word ADD KEY `object_count` (`object_count`)