Hi,
thank you for this hint. That worked excellent! Now the overall query
time is about 0.1 s on average.
Best regards,
Merlin
On Sat, 27 May 2006 02:14:34 -0700, "Merlin" <[EMAIL PROTECTED]> said:
> Well this is exactly the problem. The OR statement. Do you think there
> is
> another way aroun
Well this is exactly the problem. The OR statement. Do you think there
is
another way around the tmp table. I did not make the best experiances
with tmp tables.
regards,
merlin
On Sat, 27 May 2006 00:26:09 -0500, "mos" <[EMAIL PROTECTED]> said:
> Merlin,
> Lose the "OR" part of the Where
Merlin,
Lose the "OR" part of the Where clause and it should speed up. If so,
that's what you have to work on. You could execute 2 queries, where each
one writes the results to a temporary memory table and display that table
instead.
Mike
--
MySQL General Mailing List
For list archives: ht
