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: > create view v as select * from b where ... > sele

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; IIUC, when I execute th

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

2011-12-12 Thread Black, Michael (IS)
Why do you have a subselectwhat are you doing there that you can't do in the "on" clause? Can you show your subselect? Your example isn't enough. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information