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

Timeout when related content has too many reverse relations

    XMLWordPrintable

Details

    • [3.0] - Sprint 13

    Description

      Take 2 contents : Content A (article with an object relation field) and Content B :

      • Edit A and add a relation to B using the objectRelation field.
      • Repeat the first step X times with X different articles.
      • Display A in the admin => the page will timeout (or take a very long time to load).

       

      In my case X == 61k. I checked the ContentViewController code and displaying A will invoke loadReverseRelations() for each object linked to A. So it will load all reverse relations of B, giving more than 61k results.

      As you can imagine, it becomes even more problematic when A has multiple relations like that.

      I join a screenshot of the profiling using blackfire.

      Attachments

        Activity

          People

            Unassigned Unassigned
            julien.montavit@publish-it.fr julien.montavit@publish-it.fr
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: