On Fri, Jun 28, 2013 at 6:32 AM, Eduardo <emorr...@yahoo.es> wrote: > 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? >
SQLite does not distinguish between ON and WHERE for inner joins. In fact, one of the very first analysis steps is to take all of the ON clauses from inner joins and move them into the WHERE clause. So probably this won't make a difference. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
