Hi
I have an excel application and I am starting to work with Oracle.
when the user pushes a button the data in the sheet need to be updated in the Oracle DB. I created a loop on all records in the excel sheet, and I am using a recordset.
[VBA]dim RS as ADODB.Recordset
for lRow = 1 to 10,000
RS.AddNew
RS(1) = cells(lRow,1)
RS(2) = cells(lRow,2)
...
RS(200) = cells(lRow,200)
RS.Update
next lRow
[/VBA]
I used such code in the past with SQL server and it was very fast.
now that i use it for Oracle it takes almost 2 minutes for 10,000 records. that is a lot of time for my application. is ther a way to make it faster?