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 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 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: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > Merlin > [EMAIL PROTECTED] > > -- > http://www.fastmail.fm - Same, same, but differentÂ… > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- Merlin [EMAIL PROTECTED] -- http://www.fastmail.fm - Choose from over 50 domains or use your own -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]