Comment 2 for bug 1918145

Revision history for this message
Rodolfo Alonso (rodolfo-alonso-hernandez) wrote :

Hello Leduc:

I can't reproduce those queries in my env. I tried creating 300 projects, 300 networks (one per project) and sharing each network with each project (not a full 300-to-300 matrix, but I have more than 2000 rbac objects). When I try to reproduce [1], I have [2]. My query only examines 10 rows.

Some questions:
- Do you have [3] in your code?
- How much time does your system take to execute "openstack network list"?

Regards.

[1]http://paste.openstack.org/show/803337/
[2]http://paste.openstack.org/show/804174/
[3]https://review.opendev.org/c/openstack/neutron/+/720051