Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-13974

Store and utilize which side the origin is stored in the relationshipreferences table.

    Details

    • Target Version/s:
    • Verified Version/s:
    • Story Points:
      5
    • Sprint:
      2019.15 - IDM

      Description

      Currently the two relationship join queries (VertexEdge and EdgeVertex) union 2 large select statements, for every resource collection, in order to capture if the origin of the relationship request is referenced in the relationship table on the FIRST or SECOND set of relationship columns.  With the introduction of the relationshipreferences table, from OPENIDM-13632, we can also store which side of the relationship table holds the reference to the origin resource.  We would then only need to union only the sides that have existing references.  This will further improve performance.

        Attachments

          Activity

            People

            • Assignee:
              jason.vincent jason vincent
              Reporter:
              jason.vincent jason vincent
              QA Assignee:
              Alexander Dracka
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: