ADO recordset into memory but want direct to file...? 1

[jballum]

Hi,

Is there a way using ADO to execute a SQL statement that instead of returning the recordset into a memory object that I can return it writing directly to a file object?

Currently, I am getting the record set and then writing it to file but during some testing I realized that when the record set is really large it consumes all of the machines memory and it's virtual memory as well before getting the chance to write to file (it is only 256megs for each but still).

I am using ASP pages to call functions in a DLL developed in VB.

Thanx

JB

 

[Swany]

See this article on opening ADO recordsets into ADO streams..

http://msdn.microsoft.com/library/d...ry/en-us/ado270/htm/mdmscresultsetstreams.asp

 

[IonelBurtan]

I think you need somethiong like an Recordset object persistence:

ADODB Recorset have a method named SAVE which allow you to save two formats:
-ADTG format
-XML format
To later read from this files you will have to pass the filename as a parameter for the Open method of the Recordset.

PERSONAL NOTE:
I had used it in creating a web server, for storing security info and it works very fast.

Hope this helps,s-)
Blessed is he who in the name of justice and good will, shepards the week through the valley of darknees...

http://home.domaindlx.com/ionelb

 

[Swany]

Persisting recordsets won't work because a recordset needs to be open and stored in memory to persist it. He is running out of memory when the recordset opens because the dataset is too large for memory.

By buffering the data to an ADO stream, he can write the data directly to file w/out it getting stored in memory.