Re: [sqlite] Indices and Joins

2005-01-05 Thread Thorsten Schuett
On Wednesday 05 January 2005 13:05, D. Richard Hipp wrote: > Thorsten Schuett wrote: > > have I missed something obvious or is my explanation that bad? > > Your original posting was lengthy and dense. I doubt many people took > the time to read it. Thanks for the kind paraphras

Re: [sqlite] Indices and Joins

2005-01-05 Thread Thorsten Schuett
Hi, have I missed something obvious or is my explanation that bad? I would really like to promote sqlite in our group but if joins are so slow that won't happen. Any advice? Thorsten On Monday 03 January 2005 17:14, Thorsten Schuett wrote: > Hi, > > I am currently porting an applica

[sqlite] Indices and Joins

2005-01-03 Thread Thorsten Schuett
Hi, I am currently porting an application from a custom db backend to sqlite and have some difficulties understanding how sqlite uses indices in joins. I have several tables (MDCATTR_*) which have two columns mdc_oid and mdc_value. I have for testing created indices on mdc_oid, mdc_value and