yahoo-eng-team team mailing list archive

[Samuel de Medeiros Queiroz <samuel@xxxxxxxxxxxxxxx>]

Invalidated in favor of the created blueprint to fix this [1].

[1] https://blueprints.launchpad.net/keystone/+spec/list-role-
assignments-performance

** Changed in: keystone
       Status: In Progress => Invalid

-- 
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):
  Invalid

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 should 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 would 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/498a0032db89997244d3dc7e65ce9b37eac84283/keystone/assignment/controllers.py#L860-L864

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