Exporting large amount of data

Guest · Post by **Guest** » Wed 15 Dec 2004 15:55

Hi.

I am trying to export table of 1.5m records into csv file using ODAC.

My application consumes incredeble amount of memory and it is increasing with every row fetched

Any Suggestions?

Mike

brekhof · Post by **brekhof** » Wed 15 Dec 2004 20:03

http://crlab.com/forums/viewtopic.php?t=125

I guess you could use the same solution I use (disconnect and reconnect every x000 records)

hth
Martin

Bagieta · Post by **Bagieta** » Thu 16 Dec 2004 08:20

But if you disconnect and reconnect you are loosing your cursor and must open your table once again. Also the data can be changed. Or I'm wrong?

Paul · Post by **Paul** » Thu 16 Dec 2004 09:19

Please use TOraQuery.UniDirectional=True. ODAC will use one memory buffer for all receiving records.

brekhof · Post by **brekhof** » Thu 16 Dec 2004 11:25

Bagieta wrote:But if you disconnect and reconnect you are loosing your cursor and must open your table once again. Also the data can be changed. Or I'm wrong?

You are probably right, but the alternative is huge memory consumption (or the uni-directional solution, never tried it)

Bagieta · Post by **Bagieta** » Thu 16 Dec 2004 14:22

Can the unidirectional be set in a runtime. The question is if I can use before opening a query, or after it or during creation a new query object?

Paul · Post by **Paul** » Fri 17 Dec 2004 07:39

No. You can set UniDirectional if TOraQuery is closed.