>HI,
>Is there a way to control the autocommit with ADO and Oracle 7 within VB? I would like to know if autocommit is on or not when I issue an INSERT command. I have to Insert nearly 400000 rows that are in an Access Database and it takes 8-10 hours to complete.
>
>Thank you,
>Christian Cote
The advise Eric gave you to this is the best you can probably do. Turning autocommit on or off will not really have an affect on performance. Each record inserted ultimately has to be committed.
What dropping indexes prior to inserting does will certainly increase performance. If you do not, then the indexes get updated after each insert as opposed to once if re-created after the data loading is complete.
Mark McCasland
Midlothian, TX USA