Hi you could try:
1. disable autocommit while inserting those records, then commit after
finished.
2. You could try insert multiple column like this
insert into tableX values (a,b,c), (c,d,e), (e,f,g) .......
CMIIW
Vinay wrote:
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.
Thanks for the help
Vinay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
