yahoo-eng-team team mailing list archive

[Lance Bragstad <lbragstad@xxxxxxxxx>]

Public bug reported:

To manage hierarchical multi-tenancy (HMT) effectively the introduced
adjacency list field 'parent_id' is not enough and requires recursion to
traverse the tree, which can negatively impact performance in
deployments the complex hierarchical structures.

The materialized path concept gives us the ability to find all
ascendants and descendants of a particular node in a single request
operation.

** Affects: keystone
     Importance: Wishlist
         Status: Triaged


** Tags: hierarchical-multitenancy performance sql

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/1816109

Title:
  RFE: Add materialized path to project model

Status in OpenStack Identity (keystone):
  Triaged

Bug description:
  To manage hierarchical multi-tenancy (HMT) effectively the introduced
  adjacency list field 'parent_id' is not enough and requires recursion
  to traverse the tree, which can negatively impact performance in
  deployments the complex hierarchical structures.

  The materialized path concept gives us the ability to find all
  ascendants and descendants of a particular node in a single request
  operation.

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1816109/+subscriptions