Hi, I'm trying to add large no. of records into a Informix DB using odbc and RDO/RDC. I have to add a few hundred thousand record in a batch processing. My problem is, after adding a few thousand records the memory run's out. I have tried to close and open the RDC connection but it did not work. My coding looks like this
Do While FILELOOP < MaxLoop
If (TransLoop = 0) Then
TransLoop = TransLoop + 1
If (TransLoop = 1000) Then
RDC_Real.SQL = "select * from table"
TransLoop = 0
Is there any better way to do this and how to "Flush" the memory so that it won't run out?