Re: [sqlite] Problem with indexes and speed

"Mike Martin" wrote in message news:ecc841d80901170913rc46c75dhfc5eefc6c25f...@mail.gmail.com > Is it possible to do an index on a substring of a field > eg: subtr(start,10) to get just the day No, SQLite can't do that. Igor Tandetnik ___ sqlite-use

Re: [sqlite] Problem with indexes and speed

Thanks for that Is it possible to do an index on a substring of a field eg: subtr(start,10) to get just the day On 17/01/2009, Igor Tandetnik wrote: > "Mike Martin" wrote > in message > news:ecc841d80901170714l745078a4uf228f9c8a584f...@mail.gmail.com >> The following query runs in around 10 se

Re: [sqlite] Problem with indexes and speed

"Mike Martin" wrote in message news:ecc841d80901170714l745078a4uf228f9c8a584f...@mail.gmail.com > The following query runs in around 10 secs with no indexes, however if > I index the start field (datetime) it takes around 10 minutes + > Select guide.id,channels.Channel,start,start,name,stop,stop,c

[sqlite] Problem with indexes and speed

Hi I have a relatively simple DB with sqlite 3.5.6 The following query runs in around 10 secs with no indexes, however if I index the start field (datetime) it takes around 10 minutes + Select guide.id,channels.Channel,start,start,name,stop,stop,cat0 from guide join channels on pnr=ind left join