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
>
>
