Hi, insert into 321st_stat select * from stat_in group by <primary key fields from 321st_stat table>;
did you try to use this query? Best regards, Mikhail. ----- Original Message ----- From: "matt ryan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 19, 2004 6:06 PM Subject: 1 day 28 min insert > I think oracle parallel query is calling me > > 110,832,565 stat records > > 77,269,086 on weekly update, I get small daily files, but daily sql's > dont work very well, and miss records, in this case it missed 563 records. > > mysql> update stat_in set ctasc='321ST'; > Query OK, 77269086 rows affected (24 min 17.60 sec) > Rows matched: 77269086 Changed: 77269086 Warnings: 0 > > mysql> insert ignore into 321st_stat select * from stat_in; > Query OK, 563 rows affected (1 day 28 min 35.95 sec) > Records: 77269086 Duplicates: 77268523 Warnings: 0 > > I just cant deal with speeds this slow, an insert onto a table with a > primary key that tosses out almost all records shouldnt take this long to do > > -- > 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]
