yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** No longer affects: glance/kilo

** Tags removed: kilo-rc-potential

-- 
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

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