On Wed, 26 Jun 2013 14:23:50 -1000 Elan Feingold <e...@plexapp.com> wrote:
> The crux of the query which makes it pathologically slow in 3.7.15+ appears > to be this bit: "join metadata_item_settings on > metadata_item_settings.guid=grandchild.guid ****and > metadata_item_settings.account_id=1****". If I take out the account_id bit, > it's then fast on every version. Can you try "moving metadata_item_settings.account_id=1" from the join to WHERE? > > Where is it spending all this time? I'm glad you asked: > https://dl.dropbox.com/s/vnfv5n7m2vgn1p4/2013-06-26%20at%202.21.58%20PM.png > > Please let me know if you have any other questions! > > -elan -- Eduardo <emorr...@yahoo.es> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users