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 adding
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 records).
But because you repeat
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 AS BattingTeam"
> "5","13"
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
4 matches
Mail list logo