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

Loading lots of drafts per user results in significant performance drop when using dashboard

    Details

      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

      1. tmp.sql
        2 kB
        Konrad Oboza

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Konrad Oboza
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: