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

Significant performance drop on dashboard when user has lots of drafts

    XMLWordPrintable

    Details

    • Sprint:
      [3.0] - Sprint 12

      Description

      Customer observed that dashboard is loading really slow when many drafts are fetched.

      Steps to reproduce:
      1. Create many drafts (> 5000).
      2. Log in to the BO.

      Result:
      Dashboard is loading really slow.

      Additional information:
      In the attachment, there is an excerpt of the example query which takes much time to execute. The bigger amount of drafts is created, the bigger final query is generated.
      It is initialized while creating "Me->Drafts" tab.
      ref: https://github.com/ezsystems/ezplatform-admin-ui/blob/1.4/src/lib/UI/Dataset/ContentDraftsDataset.php#L57
      The final query is generated here:
      https://github.com/ezsystems/ezpublish-kernel/blob/7.4/eZ/Publish/Core/Persistence/Legacy/Content/Gateway/DoctrineDatabase.php#L2032

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              konrad.oboza@ez.no Konrad Oboza
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: