Glance

weather applet crashes on logout

Bug #1211316 reported by Manimekalai
This bug report is a duplicate of:  Bug #1211315: optimize queries for image-list . Edit Remove
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Glance
New
Undecided
Feilong Wang

Bug Description

Get image list take lot of time for certain image-list criterias. Found through the explain plan and slow query logs that there is a full table scan happening on certain scenarios.

The fix is to refactor the get_image_list query building code to avoid full table scan and hence reduce the response time taken.

Revision history for this message
Feilong Wang (flwang) wrote :

Hi Manimekalai, I'm working on a similar mysql performance issue, see https://bugs.launchpad.net/glance/+bug/1212082 . So I'd like to get more background about this, such as what's the "certain iamge-list criteria" you mentioned, how many images in your DB, are they associated with tags and properties, etc. Thanks.

Changed in glance:
assignee: nobody → Fei Long Wang (flwang)
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.