Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-8160

Relation tab performs an expensive search on rendering

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5
    • Fix Version/s: 5.5.0-HF15, 5.6-RC1, 5.6
    • Component/s: Relations

      Description

      When rendering the relation tab, an expensive sql query is done to retrieve all but the document.
      This request is done by the relation_search page provider
      /nuxeo-platform-relations-web/src/main/resources/OSGI-INF/contentviews-contrib.xml

                <fixedPart>
                  ecm:uuid != ? AND ecm:mixinType != 'HiddenInNavigation' AND
                  ecm:mixinType != 'Folderish' AND ecm:isCheckedInVersion = 0
                </fixedPart>
              </whereClause>
              <sort column="dc:title" ascending="true" />
              <pageSize>5</pageSize>
      

      This request is done each time the relation tab is rendered.
      This request should be done only when searching for a document to create a new relation.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: