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

Superfluous join in find-relationships-by-resource query

    XMLWordPrintable

    Details

      Description

      The first join in the find-relationships-for-resource query for MySql (and possibly all other jdbc repos) has a join to the objecttypes table which seems to be unnecessary, as the query is against the relationships table, not the genericobjects table. This will make this oft-used query slower than it could be, though the overhead of this superfluous join is probably not significant.

        Attachments

          Activity

            People

            • Assignee:
              joy.feng Joy Feng [X] (Inactive)
              Reporter:
              dhogan Dirk Hogan
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: