fetchsize question

[sunil]

I have a basic question for ado .net.

Suppose i want to retrieve 1 billion records data(4 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.


Regards,
sunhcl

 

[William \(Bill\) Vaughn]

My question would be: What the heck are you going to do with 1 billion rows
and what makes you think you can fetch a rowset that large? Are you
processing them and returning them to the server or doing some sort of
aggregation? In either case, the work should be done on the server--not on
the client.

--
__________________________________________________________________________
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
____________________________________________________________________________________________

 

[sunil]

Hi ,

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.

In nut shell , Is there any way to dump the huge query result to file.

Regards,
sunhcl

 

[William \(Bill\) Vaughn]

SSIS is designed to move data in either direction. I would check it out.

--
__________________________________________________________________________
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
____________________________________________________________________________________________

 

[sunil]

Unfortunately my system is oracle based.. what is the best approach
for oracle ?

 

[William \(Bill\) Vaughn]

SSIS. Many Oracle shops buy a SS license just to get SSIS. SSIS is system
agnostic.

--
__________________________________________________________________________
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
____________________________________________________________________________________________