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
Hi there,
I am using mysql 4.0.18 and do want to do the following:
There is one table with classifieds that contains the title and the
text. Another one contains tags associated with the classifieds. Each
classified row can have multiple tags inside the tag table. The tag
table contains the ad_id