Re: [sqlite] EXT :Re: Poor performance with nested query in outer join

2011-12-12 Thread Richard Hipp
On Mon, Dec 12, 2011 at 9:33 AM, Nick Smallbone wrote: > "Black, Michael (IS)" > writes: > > > Why do you have a subselectwhat are you doing there that you can't > > do in the "on" clause? > > In the "real" example I'm joining with a view: >

Re: [sqlite] EXT :Re: Poor performance with nested query in outer join

2011-12-12 Thread Nick Smallbone
"Black, Michael (IS)" writes: > Why do you have a subselectwhat are you doing there that you can't > do in the "on" clause? In the "real" example I'm joining with a view: create view v as select * from b where ... select * from a left natural join v where id = 1;

Re: [sqlite] EXT :Re: Poor performance with nested query in outer join

2011-12-12 Thread Black, Michael (IS)
nformation Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Nick Smallbone [n...@8325.org] Sent: Saturday, December 10, 2011 4:35 PM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] Poor performance with nested quer