yahoo-eng-team team mailing list archive

[Ann Kamyshnikova <akamyshnikova@xxxxxxxxxxxx>]

Public bug reported:

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). Analysis shows that listing can be
made on 15% faster(with larger number of security  groups can be 2-3
times faster) by adding lazy join to backref to SecurityGroupRule model.

** Affects: neutron
     Importance: Undecided
     Assignee: Ann Kamyshnikova (akamyshnikova)
         Status: New


** Tags: db juno-backport-potential

** Changed in: neutron
     Assignee: (unassigned) => Ann Kamyshnikova (akamyshnikova)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1426383

Title:
  Listing security-groups takes long time

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  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). Analysis shows that listing
  can be made on 15% faster(with larger number of security  groups can
  be 2-3 times faster) by adding lazy join to backref to
  SecurityGroupRule model.

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1426383/+subscriptions