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

Partitioning the Relationships Table

    Details

    • Target Version/s:
    • Support Ticket IDs:

      Description

      I would like to separate the single relationships table into multiple relationships tables based on the types of relationships between objects. 

      For instance, managed/user to managed/role relationships would exist in one table and managed/policy to managed/tenant relationships would exist in a completely different table.

      We are seeing a degradation in performance as the number of aggregated relationships grows from hundreds of thousands to millions (or tens of millions) of relationships and there is only so much you can do with indexes to achieve acceptable performance. 

      Certain relationships are queried more often than others and providing some method of separation would allow us to minimize the amount of time associated with more frequently accessed queries.  

        Attachments

          Activity

            People

            • Assignee:
              dhogan Dirk Hogan
              Reporter:
              bill.nelson@identityfusion.com Bill Nelson
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: