yahoo-eng-team team mailing list archive

[OpenStack Infra <1525740@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://review.openstack.org/257086
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=57964df5c6e4d590516ae7eb1783f694fa24f501
Submitter: Jenkins
Branch:    master

commit 57964df5c6e4d590516ae7eb1783f694fa24f501
Author: Kevin Benton <blak111@xxxxxxxxx>
Date:   Sun Dec 13 17:56:57 2015 -0800

    Use a joined relationship for AZ info on networks
    
    The previous code was doing a DB lookup for each network's
    availability zone which was significantly impacting the
    performance of network listings.
    
    This patch adjusts the network model to be automatically joined
    to the DHCP agents table that the AZ code uses to populate the
    AZs for the network.
    
    Change-Id: I908ceb1a68e0eed7c304e3ff82279ad6fa406167
    Closes-Bug: #1525740


** Changed in: neutron
       Status: In Progress => 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/1525740

Title:
  network availability zone code causes lookups for every network

Status in neutron:
  Fix Released

Bug description:
  the code to populate network info with availability zone info is
  causing a database lookup in every network dictionary extend function.
  This causes a major regression in network listing performance by doing
  1 DB call per database.

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