Reviewed: https://review.openstack.org/258301 Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=0b2fa9540655b27e5dc079dade29f232cadc0531 Submitter: Jenkins Branch: master
commit 0b2fa9540655b27e5dc079dade29f232cadc0531 Author: Kevin Benton <blak...@gmail.com> Date: Tue Dec 15 22:49:50 2015 -0800 Use a joined relationship for AZ info on routers This patch adds a joined relationship from the routers to the agent table to prevent excessive DB lookups of the agent availability zones during router listings. This fix is the same as the one for networks here: I908ceb1a68e0eed7c304e3ff82279ad6fa406167 A follow-up patch will add an AZ table so this doesn't have to join directly to the agents table. Change-Id: I808f8ff0c581478b2ea1144e297d83af599a32f2 Closes-Bug: #1526644 ** 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/1526644 Title: availability zones code issuing query for every router Status in neutron: Fix Released Bug description: the router availability zone code suffers from the same problem described in https://bugs.launchpad.net/neutron/+bug/1525740 but for router listing instead of network listing. This degrades the response time of router list operations. To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1526644/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp