Comment 10 for bug 1658817

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

Reviewed: https://review.openstack.org/425061
Committed: https://git.openstack.org/cgit/openstack/neutron-fwaas/commit/?id=b3abd7dfafbff913eb94e7640a2656774699a9a3
Submitter: Jenkins
Branch: stable/newton

commit b3abd7dfafbff913eb94e7640a2656774699a9a3
Author: Cedric Brandily <email address hidden>
Date: Mon Jan 23 23:37:48 2017 +0100

    Optimize _make_firewall_dict_with_rules db queries

    This change optimizes _make_firewall_dict_with_rules implementation by
    getting rules for a firewall in one db query instead of one db query per
    rule (previous implementation). It improves performance: typically on
    my deployment _make_firewall_dict_with_rules for a firewall with 1000
    rules takes 0.2s instead of 12s with previous implementation.

    Change-Id: Ia5cd39ec4ee388fab21884d08e2b19f6f6c484d5
    Closes-Bug: #1658817
    (cherry picked from commit 8a97921783cc4b7aae2b0c2fd764813fa0aa2821)