Uploaded image for project: 'Ibexa IBX'
  1. Ibexa IBX
  2. IBX-5388

Adding or removing fields in content type don't scale properly

    XMLWordPrintable

Details

    • v5 LTS - Sprint 4
    • Ibexa Open Source
    • Yes

    Description

      Steps to reproduce:

      1. Use Symfony in debug mode.
      2. Add plenty of "Folder" contents - it can be 1000 or more.
      3. Update "Folder" Content Type and add any field to it.
      4. Save.
      5. Can be repeated for deleting a fieldtype as well.
      6. Observe the performance of POST request, both in terms of time and Doctrine queries.

      Result:
      Depending on number of contents a request can timeout or just take a really long time. Amount of queries run is ~3 x number of contents, some installations have millions of contents which results in the functions being unusable.

      Expected result:
      Implement proper scaling for this functionality.

      Note:
      The issue comes from ContentUpdater\Action\AddField and ContentUpdater\Action\RemoveField being used for every content.

      Designs

        Attachments

          1. screenshot-1.png
            screenshot-1.png
            114 kB
          2. screenshot-2.png
            screenshot-2.png
            56 kB
          3. screenshot-5.png
            screenshot-5.png
            109 kB
          4. screenshot-6.png
            screenshot-6.png
            55 kB

          Activity

            People

              Unassigned Unassigned
              bartlomiej.wajda@ibexa.co Bartłomiej Wajda
              Votes:
              2 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: