yahoo-eng-team team mailing list archive

[OpenStack Infra <1526644@xxxxxxxxxxxxxxxxxx>]

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 <blak111@xxxxxxxxx>
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