> I am using mysql5.0 on Hp-UX. IT took about 14 hours to insert 1.7 millin > records. How do I make >my insert run faster.The table has three foreign key > references and the referencing columns are >indexed . Is that impacting the > insert statement performance.
Just thought I'd add a little to the good advice already given to you. I find an easy way to derive the extended insert syntax is to perform a mysqldump of a small table. >From 4.1 onwards this wrapped the table dump in the extended insert syntax. Regards, Imran -- http://www.ImranChaudhry.info MySQL Database Management & Design Services -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
