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]