Bad performance when editing project members

On the keystone side, this is specifically addressed by https://blueprints.launchpad.net/keystone/+spec/list-limiting

On the horizon side, horizon should issue queries to keystone with as many filters as reasonably possible to avoid hitting the truncation behavior implemented above.

One more things affecting the "edit project" performances (not speed related but more about usability) is that the user list should be either paged or limited to just a few users with a pointer to the filtering field.

Currently it is providing a single, unsorted list, of all users which isn't of great help I think.

This issue is due to single calls triggered for each user that has a role in a project: https://github.com/openstack/horizon/blob/master/openstack_dashboard/dashboards/admin/projects/workflows.py#L209

And it can be easily addressed by fetching all roles in a project scope using just a single API call: /v3/role_assignments?scope.project.id=<project_id>. But, the /v3/role_assignments endpoint is not supported by OSC yet, therefore is not implemented at keystoneclient: https://bugs.launchpad.net/python-keystoneclient/+bug/1246310

About usability issues, maybe is better to open another bug/blueprint related just to UI usability improvement?

What do you think?

Rodrigo: this bug doesn't seem to concern anything but performance & user experience - what do you want to track that's separate from that and bug 1246310?

Although this bug can address both performance & user experience, the problems cited by Giulio seems to have a different scope?
My thoughts are to attack https://bugs.launchpad.net/python-keystoneclient/+bug/1246310 first and than resolve this bug. Makes sense?

Agree it makes sense to address bug 1246310 first, and then utilize that in horizon to address the concerns here.

Patch submitted: https://review.openstack.org/#/c/92412/

Image without the fix applied as attachment.

Image with the fix applied as attachment.

Reviewed: https://review.openstack.org/92412
Committed: https://git.openstack.org/cgit/openstack/horizon/commit/?id=ed43be0a0f40c4b065472da27e6ef6e59a6789ca
Submitter: Jenkins
Branch: master

commit ed43be0a0f40c4b065472da27e6ef6e59a6789ca
Author: Rodrigo Duarte Sousa <email address hidden>
Date: Tue Jun 10 10:22:51 2014 -0300

    Fixes bad performance when editing project members

    The bug is caused by consecutive client calls when
    fetching users' roles in a project.

    The fix was to use the /v3/role_assignments endpoint.
    Which retrieves all roles in a single client call
    (dashboards/admin/projects/workflows.py:
    UpdateProjectGroupsAction and UpdateProjectUsersAction).

    The compatibility to the previous keystoneclient version
    is maintained.

    In a scenario with 1000 users with a role in a project
    (using devstack), the time to render the Modify Users
    page dropped from 45s to 2.5s

    Change-Id: Ic72ebea0db226faf98c5e04d00d76dedd1fb01c1
    Closes-bug: #1278920

Fix proposed to branch: stable/icehouse
Review: https://review.openstack.org/110136

Change abandoned by Justin Pomeroy (<email address hidden>) on branch: stable/icehouse
Review: https://review.openstack.org/110136
Reason: The keystoneclient requirement means we can't back port this easily.

Change abandoned by Justin Pomeroy (<email address hidden>) on branch: stable/icehouse
Review: https://review.openstack.org/110136
Reason: I don't think this is going to be accepted for icehouse. No reason to keep it hanging around.