fetch size

[sunil]

I have a basic question for ado .net.

Suppose i want to retrieve 1 billion records data(1 GB). and suppose i
set the fetchsize to 128 MB.
Does this mean that at one time i will be having 128 MB records at a
time in memory.

I am not sure whether i will be having 128 MB results in memory or 4
GB results in memory.

I need to dump all of this information to a log files.

We already have a tool that can interpret these 10 GB log to do its
own internal analysis of huge data.



Regards,
sunhcl

 

[William \(Bill\) Vaughn]

I suggest (again) that you use SSIS to dump the contents--not ADO.NET. It's
designed to handle query results--not bulk data.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com/blog/billva
____________________________________________________________________________________________