Re: [sqlite] Slowdown when adding terms to query

Thank you all for your responses, Igor - using a UNION made a huge difference, thank you. I have a quick query on from the suggestion of adding indices for anything that appears either side of an equals sign. I have many user-selectable terms that can be added to the query. Is it worth

Re: [sqlite] Slowdown when adding terms to query

Edward Hawke wrote: > 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

Re: [sqlite] Slowdown when adding terms to query

On Fri, Aug 6, 2010 at 5:23 AM, Edward Hawke wrote: > > I have done an EXPLAIN QUERY PLAN on the query, which gave me the > following: > > "0","2","TABLE Tour" > "1","4","TABLE Country" > "2","1","TABLE Match" > "3","11","TABLE Team AS BowlingTeam" > "4","12","TABLE Team