yahoo-eng-team team mailing list archive

[Alan Pevec <1298053@xxxxxxxxxxxxxxxxxx>]

** Also affects: neutron/havana
   Importance: Undecided
       Status: New

** Changed in: neutron/havana
       Status: New => In Progress

** Changed in: neutron/havana
   Importance: Undecided => High

** Changed in: neutron/havana
     Assignee: (unassigned) => Aaron Rosen (arosen)

** Changed in: neutron/havana
    Milestone: None => 2013.2.3

** Tags removed: havana-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/1298053

Title:
  Subnets should be set as lazy='join'

Status in OpenStack Neutron (virtual network service):
  Fix Committed
Status in neutron havana series:
  In Progress

Bug description:
  Currently if one does a net-list tons of queries are issued against
  the database as the default query mode is 'select' which performs a
  query when the field is actually accessed. In this patch I change the
  the mode to 'joined' so subnets are loaded as the networks are loaded.
  Usually there are only 1 or 2 subnets on a network so loading this
  data shouldn't help. This patch in my setup with 5000 networks reduces
  the net-list call from 27 seconds to 7!

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