]> review.fuel-infra Code Review - openstack-build/neutron-build.git/commit
Make listing security groups faster
authorAnn Kamyshnikova <akamyshnikova@mirantis.com>
Fri, 27 Feb 2015 14:06:43 +0000 (17:06 +0300)
committerAnn Kamyshnikova <akamyshnikova@mirantis.com>
Fri, 27 Feb 2015 14:14:29 +0000 (17:14 +0300)
commit5917fcff32a51e755b7bb90790cac5afd92556e8
treed4ec380790deb47e1987d91fe39d479bb651844d
parent9d5e2b9b01c077c2d850b21929e36b466b86cd5f
Make listing security groups faster

If we have a large number of security groups (more than 1000) with
security group rules (about 100 for each group) listing them
could take rather long time(more than 1 minute).

Adding lazy join to backref to SecurityGroupRule model will make
it faster at list on 15%.

Change-Id: I648a48cdefe0faf75c0c62bd8adffc12547293be
Closes-bug: #1426383
neutron/db/securitygroups_db.py