memory usage with TOracleDataSet

[tschuk]

Hello,

i want to copy some row's of LONG RAW data from a paradox table into my oracle database (8.1.5. WinNT) via DOA 3.3.3. TOracleDataSet.

I opened a query of the paradox table and tried to append the record to the oracle dataset for each record in the original query. The problem i encountered is the following:

- i use the TBlobField component to copy the binary data from paradox to oracle (TOracleDataSet is inherited the TDataSet properties and methods i.e. (FieldByName ('xxx') as TBlobField))
- i post the record to the oracle database
- the memory usage of the process increases with every record

what happens ? What can i do to copy the data in this manner without the high memory load (>400MB) ?

 

[Marco Kalter]

If you want to insert or update a lot of long raw data, you should probably use SQL insert or update statements instead of posting the data in a dataset.

------------------
Marco Kalter
Allround Automations