Details
-
Bug
-
Resolution: Fixed
-
Medium
-
None
-
3.10.0, 3.9.4, 4.0.0, 4.0.0beta1, 4.0.0rc1
-
None
Description
Please add the following indexes to ezinfocollection_attribute
ALTER TABLE `ezinfocollection_attribute`
ADD INDEX `Index_3`(`contentobject_id`),
ADD INDEX `Index_4`(`contentobject_attribute_id`),
ADD INDEX `Index_5`(`contentclass_attribute_id`),
ADD INDEX `Index_6`(`informationcollection_id`);
Note: 'Index_3' already exists in newer eZ versions but we need the rest too.
we have 40000 rows of data in ezinfocollection_attribute the performance is just too bad when exporting the data. Each query to eZInformationCollection::informationCollectionAttributes took 1 sec to execute. I just can`t wait > 11 hours till all data is exported.
Attachments
Issue Links
- relates to
-
EZP-13606 Optimisations: missing indexes
- Closed