Re: fetchsize question

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



On Nov 19, 11:26 am, "William \(Bill\) Vaughn"
<billvaNoS...@xxxxxxxxx> wrote:
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" <sun...@xxxxxxxxx> wrote in message

news:7622480c-cd59-4e61-8973-a3d55c13fe60@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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

.

Relevant Pages

  • Re: fetch size
    ... I suggest that you use SSIS to dump the contents--not ADO.NET. ... It's designed to handle query results--not bulk data. ... I am not sure whether i will be having 128 MB results in memory or 4 ... I need to dump all of this information to a log files. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: basic tlog question
    ... Yes, the log records are written to memory too, to an area called 'log ... written to log files, before the associated dirty pages are written to disk. ... Vyas, MVP (SQL Server) ... I understand the part where dirty pages are written to disk.. ...
    (microsoft.public.sqlserver.server)
  • Daily Report #4852
    ... Verify Guide Star Acquisition with Continuing FGSs ... Load and Dump Onboard Memory ... At the beginning of each test, the attitude control law ...
    (sci.astro.hubble)
  • Problems installing 5.1A on XP1000
    ... The drive I'm attempting an install to is an IBM ... 640 MBytes of System Memory ... isa0 at pci0 ... DUMP: Warning: no disk available for dump. ...
    (Tru64-UNIX-Managers)
  • Booting 4.0 on XP1000
    ... available memory from 0x2ef8000 to 0x7ffec000 ... isp0 at pci1 slot 6 ... gpc0 at isa0 ... DUMP: No primary swap, no explicit dumpdev. ...
    (Tru64-UNIX-Managers)