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

Links table searched with large query when performing reconById

    XMLWordPrintable

    Details

      Description

      When performing a reconById, the full links set for the mapping is searched using the links-for-linkType query which hits a large result set:

      SELECT * FROM openidm.links WHERE linkType =$1
      

      This causes a performance decline when using a large number of reconById calls.

        Attachments

          Activity

            People

            Assignee:
            cgdrake Chris Drake
            Reporter:
            tom.wood Tom Wood
            QA Assignee:
            Tinghua Xu Tinghua Xu
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: