yahoo-eng-team team mailing list archive

[Kevin Benton <1374556@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

The RPC handler for looking up security group details for ports does it
one port at a time, which means an individual SQL query with a join for
every port on a compute node, which could be 100+ in a heavily
subscribed environment.

** Affects: neutron
     Importance: Undecided
     Assignee: Kevin Benton (kevinbenton)
         Status: In Progress

** Changed in: neutron
     Assignee: (unassigned) => Kevin Benton (kevinbenton)

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

Title:
  SQL lookups to get port details should be batched

Status in OpenStack Neutron (virtual network service):
  In Progress

Bug description:
  The RPC handler for looking up security group details for ports does
  it one port at a time, which means an individual SQL query with a join
  for every port on a compute node, which could be 100+ in a heavily
  subscribed environment.

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