sql query optimization

bozek

Joined: 2012-12-04
Posts: 4
Posted: Tue, 2012-12-04 12:11

Hello,
first of all I have to thank you all for great gallery :)
My girlfrind has more then 6000 photos in gallery 3.0.4 and I have some performance problems with that. In closer look I find that gallery makes over 3000 queris on one page click :(

More then 2700 queries are from EXIF GPS module: "SELECT `exif_coordinates`.* FROM `exif_coordinates` WHERE `item_id` = ..."

and I can not figure out from where comes next 200 queries "SELECT `items`.* FROM `items` WHERE `type` = 'album' AND `parent_id` = ..."

Does anyone have similar problems?
Is it possible to rewrite code to one query like "where item_id in (..., ..., ...)" ?

Best regards, Bozek
 
jnash
jnash's picture

Joined: 2004-08-02
Posts: 814
Posted: Tue, 2012-12-04 14:00

Please contribute here to this thread:

http://gallery.menalto.com/node/109227

Almost duplicate...
 
jnash
jnash's picture

Joined: 2004-08-02
Posts: 814
Posted: Tue, 2012-12-04 14:00

Comments are now locked for this topic.