Hi,
I have a VB program that reads about 120,000 records from a file and inserts them into an Oracle database table. The first 60,00 inserts are as fast as 50 to 70 inserts per second and it slows down after that to an average of 1 insert per second.
Are there any reasons why an insert statement takes such a long time?
Any recommnended approaches to fix the problem?
Thank you
Hind
I have a VB program that reads about 120,000 records from a file and inserts them into an Oracle database table. The first 60,00 inserts are as fast as 50 to 70 inserts per second and it slows down after that to an average of 1 insert per second.
Are there any reasons why an insert statement takes such a long time?
Any recommnended approaches to fix the problem?
Thank you
Hind