[sqlite] Slowdown when adding terms to query

Hi all, I have a query that is working at an acceptable speed, and I need to add something else to it. As soon as I add the extra terms it grinds to a halt (taking well over 5 minutes to perform the query on a relatively small dataset c.100,000 records). I've looked into the speed optimisations

Re: [sqlite] Slowdown when adding terms to query

adding indices for all of these? I have heard having too many indices can slow searches down, so I want to know where to stop, or is there no hard-and-fast rule, just test and see? Regards, Ed On 06/08/2010 13:22, Igor Tandetnik wrote: > Edward Hawke<edhawk...@googlemail.com> wrote: