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"?
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/ paste.openstack .org/show/ 804174/ /review. opendev. org/c/openstack /neutron/ +/720051
[2]http://
[3]https:/