Comment 5 for bug 1865223

Hello:

Continuing with http://lists.openstack.org/pipermail/openstack-discuss/2020-March/012931.html.

I've identified a (very good) feature that can help us on this regression. In [1][2], a lazy loader for the SG rules was implemented. That means that if the "rules" parameter is not requested in the "fields" parameter in "SecurityGroupDbMixin.get_security_groups()", the OVO do not load those parameters, reducing the load time. In an environment with 1000 SG (each one with the default 2 SG rules), the load time goes from 11.7 seconds to 3.7 seconds.

I'll propose the needed patches for OSsdk and OSclient to include this "fields" parameter in the API call in the "list" OSC command.

Regards.

[1]https://review.opendev.org/#/c/630401/
[2]https://review.opendev.org/#/c/637407/