> Put the 60K ints into a temporary table. Next join against this temporary > table. This join forces the optimizer to translate the range into an > eq_ref-one of the fastest type joins.
He could also simply use a join to the ID table, provided that the 60000 IDs are SELECTable in the current database? Anyway, I support your JOIN suggestion as joins are highly optimized and thus quite fast. Regards Fred -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
