Yes - thanks. I did not define the data with keys because it does not come out of the source that way. Keys and replace does it nicely. Probably my question defined me as a newbie, if not well...
Thank you very much for you help. On Wed, 20 Apr 2005, Duncan Hill wrote: > 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] > _____ Douglas Denault http://www.safeport.com [EMAIL PROTECTED] Voice: 301-469-8766 Fax: 301-469-0601 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
