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

Create Object Cache for ObjectTypes - generic tables then no longer join on objecttypes table.

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 7.0.0
    • Fix Version/s: 7.0.0
    • Component/s: Performance
    • Labels:
    • Target Version/s:
    • Verified Version/s:
    • Story Points:
      5
    • Sprint:
      2019.16 - IDM, 2019.17 - IDM, 2020.01 - IDM, 2020.02 - IDM

      Description

      The EdgeVertex and VertexEdge "mega" queries can benefit from not needing to join the objecttypes table for generic table references.

      Instead of joining on the objectypes table, utilize a cache of the objecttypes table data and bind the objecttype_id directly to the type of object being retrieved from the generic object table.

      The objecttype cache would need to be refreshed any time a new object type is defined or modified.

      Also improved would we would no longer need to select the objecttype_id prior to inserting any new record.

       

        Attachments

          Activity

            People

            Assignee:
            jason.vincent jason vincent
            Reporter:
            jason.vincent jason vincent
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: