yahoo-eng-team team mailing list archive

[Cedric Brandily <1658817@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

_make_firewall_dict_with_rules returns a firewall and its rules by
calling get_firewall, get_firewall_policy and get_firewall_rule for each
rule ... which implies a db query for each rule and slowness (on my
deploiement 12s to get a firewall with 1000 rules).

It seems possible to get all FW rules in one db query.

** Affects: neutron
     Importance: Undecided
     Assignee: Cedric Brandily (cbrandily)
         Status: New


** Tags: fwaas mitaka-backport-potential newton-backport-potential

** Tags added: mitaka-backport-potential newton-backport-potential

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

Title:
  _make_firewall_dict_with_rules gets FW rules one by one from db

Status in neutron:
  New

Bug description:
  _make_firewall_dict_with_rules returns a firewall and its rules by
  calling get_firewall, get_firewall_policy and get_firewall_rule for
  each rule ... which implies a db query for each rule and slowness (on
  my deploiement 12s to get a firewall with 1000 rules).

  It seems possible to get all FW rules in one db query.

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