Keystone does a select * from assignment table even if a filter is provided in the URL.

Bug #1402628 reported by Ajaya Agrawal
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Identity (keystone)
Triaged
Medium
Unassigned

Bug Description

As it stands the function list_role_assignments in the sql backend does not take any filter. So there is scope of optimization here.

Tags: performance
Dolph Mathews (dolph)
tags: added: performance
Changed in keystone:
importance: Undecided → Medium
status: New → Triaged
Dave Chen (wei-d-chen)
Changed in keystone:
assignee: nobody → Dave Chen (wei-d-chen)
Revision history for this message
Dave Chen (wei-d-chen) wrote :

Hold on to see whether the fix is still needed after assignment split is done.

Changed in keystone:
assignee: Dave Chen (wei-d-chen) → nobody
Revision history for this message
Rodrigo Duarte (rodrigodsousa) wrote :

Think it is a duplicate from bug #1359231 which is being already addressed by this review: https://review.openstack.org/#/c/137202/

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.