neutron

Listing security-groups takes long time

Bug #1426383 reported by Ann Taraday
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
neutron
Fix Released
Undecided
Ann Taraday
neutron 2015.1.0 "kilo"
Juno
Fix Released
Undecided
Ann Taraday
neutron 2014.2.3

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.

Ann Taraday (akamyshnikova)
Changed in neutron:
assignee: nobody → Ann Kamyshnikova (akamyshnikova)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (master)

Fix proposed to branch: master
Review: https://review.openstack.org/159850

Changed in neutron:
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (master)

Reviewed: https://review.openstack.org/159850
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=5917fcff32a51e755b7bb90790cac5afd92556e8
Submitter: Jenkins
Branch: master

commit 5917fcff32a51e755b7bb90790cac5afd92556e8
Author: Ann Kamyshnikova <email address hidden>
Date: Fri Feb 27 17:06:43 2015 +0300

    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

Changed in neutron:
status: In Progress → Fix Committed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (stable/juno)

Fix proposed to branch: stable/juno
Review: https://review.openstack.org/160815

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (stable/juno)

Reviewed: https://review.openstack.org/160815
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=4856743be9fa80c7196eb8df55cc6c32f74d201a
Submitter: Jenkins
Branch: stable/juno

commit 4856743be9fa80c7196eb8df55cc6c32f74d201a
Author: Ann Kamyshnikova <email address hidden>
Date: Fri Feb 27 17:06:43 2015 +0300

    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
    (cherry picked from commit 5917fcff32a51e755b7bb90790cac5afd92556e8)

tags: added: in-stable-juno
Thierry Carrez (ttx)
Changed in neutron:
milestone: none → kilo-3
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in neutron:
milestone: kilo-3 → 2015.1.0
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.