← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1359231] [NEW] List role assignments filters performance

 

Public bug reported:

When listing role assignments, we have the option to filter them by actor, target and role.
As Henry Nash pointed out at [1] , the current implementation uses the standard filtering the V3.wrap_collection. Given the large number of individual assignments, this is pretty inefficient. 

The controller must pass the filters into the driver call, so that the list size is kept a minimum.
For example, if the user wants to filter role assignments by project X, the driver will query the DB only selecting the role assignments where target_id = X.id, instead of querying everything and returning the result to be filtered by the controller.

[1]
https://github.com/openstack/keystone/blob/master/keystone/assignment/controllers.py#L860

** Affects: keystone
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/1359231

Title:
  List role assignments filters performance

Status in OpenStack Identity (Keystone):
  New

Bug description:
  When listing role assignments, we have the option to filter them by actor, target and role.
  As Henry Nash pointed out at [1] , the current implementation uses the standard filtering the V3.wrap_collection. Given the large number of individual assignments, this is pretty inefficient. 

  The controller must pass the filters into the driver call, so that the list size is kept a minimum.
  For example, if the user wants to filter role assignments by project X, the driver will query the DB only selecting the role assignments where target_id = X.id, instead of querying everything and returning the result to be filtered by the controller.

  [1]
  https://github.com/openstack/keystone/blob/master/keystone/assignment/controllers.py#L860

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


Follow ups

References