fetchsize question

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

  • fetch size
    ... Suppose i want to retrieve 1 billion records data. ... set the fetchsize to 128 MB. ... 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: Tips on finding memory leaks
    ... But when Access reports that it's using 500M of memory, ... The problem is that at least with Access as the front-end, and ADO in the ... mentioned collections and child objects along with ADO. ... what a Recordset is: "A collection of collections contains objects". ...
    (microsoft.public.vb.general.discussion)
  • Re: Recordset.AddNew and the recordset objects data retaining
    ... via an ADO recordset, then I'd strongly suggest you redesign your solution. ... > to do with the updates being in a transaction but rather on whether you specify ... > spill over and the memory starts paging out to disk that concerns me). ...
    (microsoft.public.data.ado)
  • Re: filter with vb code
    ... I guess ADO classic doesn't interest them. ... There may be no recordset in your post be there certainly is a memory ... SQL involving an open workbook causes a memory leak. ...
    (microsoft.public.excel.programming)
  • Re: Tips on finding memory leaks
    ... Any suggestions, either specific to ADO, collections, or just general to ... As for tracing memory leaks with VB, ... mentioned collections and child objects along with ADO. ... Recordset which can then be wrapped with an object to provide the same ...
    (microsoft.public.vb.general.discussion)