yahoo-eng-team team mailing list archive

[Ajaya Agrawal <ajku.agr@xxxxxxxxx>]

Public bug reported:

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

** Affects: glance
     Importance: Undecided
         Status: New

** Description changed:

  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

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