yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: neutron
       Status: Fix Committed => Fix Released

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

Title:
  Avoid extra query when loading port security binding

Status in OpenStack Neutron (virtual network service):
  Fix Released

Bug description:
  Plugins supporting the port security extension perform an extra db
  query for each element being retrieved by get_networks and get_ports
  operation.

  The extra query is performed in the following methods:
  _extend_network_port_security_dict: https://github.com/openstack/neutron/blob/master/neutron/db/portsecurity_db.py#L54
  _extend_port_port_security_dict: https://github.com/openstack/neutron/blob/master/neutron/db/portsecurity_db.py#L58

  Using similar technicques adopted for other API extensions, this extra
  query, which negatively impacts performance and scalability, should be
  removed.

  This bug affects only the nicira plugin as it is currently the only
  plugin which enables this ext.

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