]> review.fuel-infra Code Review - openstack-build/neutron-build.git/commit
Use a joined relationship for AZ info on routers
authorKevin Benton <blak111@gmail.com>
Wed, 16 Dec 2015 06:49:50 +0000 (22:49 -0800)
committerKevin Benton <blak111@gmail.com>
Wed, 16 Dec 2015 07:29:47 +0000 (23:29 -0800)
commit0b2fa9540655b27e5dc079dade29f232cadc0531
tree261bbe931e61d3c5a4e4fb5f0d55d13492ff9102
parent327c12770f0fc8d5b26891d12f7fb0b056b11b4d
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
neutron/db/availability_zone/router.py
neutron/db/l3_agentschedulers_db.py
neutron/db/l3_db.py
neutron/extensions/router_availability_zone.py