Details
-
Bug
-
Resolution: Fixed
-
Medium
-
4.0.6, 4.1.3, extension/ezoracle 1.8.2, extension/ezoracle 2.0.0
-
None
Description
Datatype keyword generates sql request like this one.
SELECT ezkeyword.keyword
FROM ezkeyword_attribute_link, ezkeyword
WHERE ezkeyword_attribute_link.keyword_id = ezkeyword.id
AND ezkeyword_attribute_link.objectattribute_id = "my_id"
Without index on "objectattribute_id" and with a lot of data, this request can be very slow.
When doing an EXPLAIN, you can see that without index, mysql fetch all the content of the keyword table.
Adding an index on objectattribute_id increases performance.
Attachments
Issue Links
- relates to
-
EZP-9091 Missing indexes in 3.8
- Closed