On Wednesday 20 April 2005 16:55, [EMAIL PROTECTED] typed: > For the small number of records, this query takes a remarkable amount of > time, so clearly this solution does not scale.
A query that uses keys should not take a long time to run - unless your key data is not maintained as a key in the SQL table. Sample data, queries and the output from EXPLAIN will probably help others to help you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]