Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Slow Oracle Database Table Inserts
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...- Hind
- Thread
- Replies: 9
- Forum: Oracle: All versions
-
Database Record lock
Hi, I need to select a record from a table on an oracle database, manipulate it and update it to the database. But after executing my select statement i want to lock that record so that nobody can read it or write to it until i finish my update.i'm using ADO. Does anybody know what the best way...- Hind
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
