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

Partitioning the Relationships Table

    XMLWordPrintable

    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: