Re: fetch size
- From: "William \(Bill\) Vaughn" <billvaNoSpam@xxxxxxxxx>
- Date: Sat, 22 Nov 2008 10:55:31 -0800
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
____________________________________________________________________________________________
"sunil" <sunhcl@xxxxxxxxx> wrote in message news:797c774d-9b2b-430b-ace0-113df7bff329@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
.
- References:
- fetch size
- From: sunil
- fetch size
- Prev by Date: fetch size
- Next by Date: Cannot connect a remote sql server
- Previous by thread: fetch size
- Next by thread: Cannot connect a remote sql server
- Index(es):
Relevant Pages
|
