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 <[email protected]> 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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
