Inefficient db call while doing a image_get with image_id.
Bug #1434578 reported by
Ajaya Agrawal
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Glance |
Fix Released
|
Low
|
Kamil Rykowski |
Bug Description
I am running MySql as backend and I can see two queries being done when I try to get an image.
In first query the tables images, image_locations and image_properties are joined and in another query tags related to that image are fetched from the db. These two can be combined to one query which will do a join of images, image_locations, image_properties and image_tags (join of these four tables happen when a call is made to get a list of all images).
Reference:
https:/
description: | updated |
Changed in glance: | |
assignee: | nobody → Kamil Rykowski (kamil-rykowski) |
Changed in glance: | |
status: | New → In Progress |
Changed in glance: | |
importance: | Undecided → Wishlist |
Changed in glance: | |
importance: | Wishlist → Low |
tags: | added: kilo-rc-potential |
no longer affects: | glance/kilo |
tags: | removed: kilo-rc-potential |
Changed in glance: | |
milestone: | none → liberty-1 |
status: | Fix Committed → Fix Released |
Changed in glance: | |
milestone: | liberty-1 → 11.0.0 |
To post a comment you must log in.
Fix proposed to branch: master /review. openstack. org/171674
Review: https:/