Hye,
I have written a program to transfer data from one oracle server to another, as part of my code i loop through each recordset deleting the records so that i can then add the new data in, the problem is this is a very slow process, can anyone think of a quicker way, an example of the code I am using is below:
orars.movirst
do until orars.eof
orars.delete
orars.update
orars.movenext
loop
Any ideas??
I have written a program to transfer data from one oracle server to another, as part of my code i loop through each recordset deleting the records so that i can then add the new data in, the problem is this is a very slow process, can anyone think of a quicker way, an example of the code I am using is below:
orars.movirst
do until orars.eof
orars.delete
orars.update
orars.movenext
loop
Any ideas??