Mike, was this a straight software upgrade on the same box? Any settings changes?
Dan On 10/6/06, mos <[EMAIL PROTECTED]> wrote:
I have a simple query in MySQL 5.0.24: insert into table1 (col1) select distinct col1 from bigtable; that will run for 1:14:18. Both tables are MyISAM and table1 was just created with 2 columns and is empty. The "select distinct col1 from bigtable" takes only 2 minutes to run if I run it by itself (without the Insert statement), so why does inserting it into Table1 take over an hour? This worked fine under MySQL 4.1.10 BigTable has 30 million rows in it and will return approx 7000 distinct values. TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]