** Also affects: glance/kilo
Importance: Undecided
Status: New
** Changed in: glance/kilo
Milestone: None => kilo-rc2
** Changed in: glance/kilo
Importance: Undecided => Low
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Glance.
https://bugs.launchpad.net/bugs/1434578
Title:
Inefficient db call while doing a image_get with image_id.
Status in OpenStack Image Registry and Delivery Service (Glance):
Fix Committed
Status in Glance kilo series:
New
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://github.com/openstack/glance/blob/master/glance/db/__init__.py#L69-74
To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1434578/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
