neutron

Avoid extra query when loading qos queue binding

Bug #1215872 reported by Salvatore Orlando
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
neutron
Fix Released
Medium
Salvatore Orlando
neutron 2013.2 "havana"

Bug Description

The nicira plugin supports the 'qos_queue' extension, and for this it performs an extra db query for each element being retrieved by the get_ports and get_networks operations.

Using similar technicques adopted for other API extensions, this extra query, which negatively impacts performance and scalability, should be removed.

This bug affects only the nicira plugin.

Tags: db nicira
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (master)

Fix proposed to branch: master
Review: https://review.openstack.org/43432

Changed in neutron:
status: New → In Progress
Salvatore Orlando (salvatore-orlando)
Changed in neutron:
milestone: havana-3 → havana-rc1
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (master)

Reviewed: https://review.openstack.org/43432
Committed: http://github.com/openstack/neutron/commit/72f85b5e616e3aabcab862b944c1a3a2c2844431
Submitter: Jenkins
Branch: master

commit 72f85b5e616e3aabcab862b944c1a3a2c2844431
Author: Salvatore Orlando <email address hidden>
Date: Thu Aug 22 09:08:52 2013 -0700

    Avoid performing extra query for fetching qos bindings

    Bug 1215872

    Add a relationship with eager loading in the Port and Network models,
    thus preventing the 'extend' functions from performing extra queries.
    This patch also slight alters the methods for processing qos_queue
    bindings in order to allow them for populating the qos_queue id in
    the response being created.

    Change-Id: Ie80d12aeed5de94afa61f23d7bcfc21372f23c4f

Changed in neutron:
status: In Progress → Fix Committed
Thierry Carrez (ttx)
Changed in neutron:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in neutron:
milestone: havana-rc1 → 2013.2
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.