Re: [sqlite] How to optimize select queries

thnx my queries are running in 1/3rd the time now!! ritesh On Mon, 2006-01-02 at 22:22, Dennis Cote wrote: > Ritesh Kapoor wrote: > > >Hi, > > > >I need to optimize/speed up my 'select' queries. The query creates > >about 3 to 6 left joins from 7 different tables depending on the > >different c

Re: [sqlite] How to optimize select queries

Ritesh Kapoor wrote: Hi, I need to optimize/speed up my 'select' queries. The query creates about 3 to 6 left joins from 7 different tables depending on the different conditions passed. The problem is that this is taking a lot of time. The table column's are of both varchar and integer types

[sqlite] How to optimize select queries

Hi, I need to optimize/speed up my 'select' queries. The query creates about 3 to 6 left joins from 7 different tables depending on the different conditions passed. The problem is that this is taking a lot of time. The table column's are of both varchar and integer types - on which comparisions