Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-12192

very bad performance in function eZInformationCollection::informationCollectionAttributes

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • None
    • 3.10.0, 3.9.4, 4.0.0, 4.0.0beta1, 4.0.0rc1
    • Database related, Misc
    • 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

        Activity

          People

            gl gl
            a7ccb6eb-752c-4f73-908e-4baabf343cdd@accounts.ibexa.co Björn Dieding
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: