Re: [sqlite] Slow Query with LEFT OUTER JOIN

2008-09-23 Thread Kees Nuyt
On Tue, 23 Sep 2008 14:37:11 -0400, Enrique Ramirez wrote: >On Tue, Sep 23, 2008 at 1:16 PM, Kees Nuyt <[EMAIL PROTECTED]> wrote: >> Steps to take (you need all of them, except 1): >> >> 1) Use v6.2.3 >> > >Probably meant to say 1) Use v3.6.2? Oops, yes. Or even better: v3.6.3 -- ( Kees Nuy

Re: [sqlite] Slow Query with LEFT OUTER JOIN

2008-09-23 Thread Enrique Ramirez
On Tue, Sep 23, 2008 at 1:16 PM, Kees Nuyt <[EMAIL PROTECTED]> wrote: > Steps to take (you need all of them, except 1): > > 1) Use v6.2.3 > Probably meant to say 1) Use v3.6.2? -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indieco

Re: [sqlite] Slow Query with LEFT OUTER JOIN

2008-09-23 Thread Kees Nuyt
On Mon, 22 Sep 2008 13:48:42 -0700, Jason wrote: >Hello everyone, > >Hoping that I could get some help with a performance problem. >Using version 3.5.2 > >Here are the tables: >CREATE TABLE Objects (ObjectId INTEGER PRIMARY KEY, Name TEXT) >CREATE TABLE Keywords4Objects (ObjectId INTEGER, Keywor

[sqlite] Slow Query with LEFT OUTER JOIN

2008-09-22 Thread Jason Tudor
Hello everyone, Hoping that I could get some help with a performance problem. Using version 3.5.2 Here are the tables: CREATE TABLE Objects (ObjectId INTEGER PRIMARY KEY, Name TEXT) CREATE TABLE Keywords4Objects (ObjectId INTEGER, KeywordId INTEGER) CREATE TABLE Keywords (KeywordId INTEGER PRIMA