yahoo-eng-team team mailing list archive

[Aaron Rosen <aaronorosen@xxxxxxxxx>]

Public bug reported:

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!

** Affects: neutron
     Importance: High
     Assignee: Aaron Rosen (arosen)
         Status: In Progress


** Tags: havana-backport-potential

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

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

** Tags added: 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):
  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