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]