Re: ADO Recordset memory problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Joyce Lau (lauj0_at_hotmail.com)
Date: 10/04/04 

Date: 4 Oct 2004 07:02:41 -0700

Thanks Val, but if I set the datatype to adVarChar(200) and with the
same data, the recordset uses even more memory, 115MB.

Joyce Lau

Relevant Pages

  • Re: ADO Recordset memory problem
    ... but if I set the datatype to adVarCharand with the ... same data, the recordset uses even more memory, 115MB. ... Joyce Lau ...
    (microsoft.public.vc.database)
  • Re: Releasing memory
    ... "nisant" wrote: ... Then use SQL to create a third recordset of the 70*3000 ... essentially defragment the memory, and that's what's taking a long time. ... >>> At program termination the db structure is released setting to nothing ...
    (microsoft.public.vb.general.discussion)
  • 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: VB6 not releasing Memory when Form is Unloaded
    ... I create a recordset and then display the results in a DataGrid using ... I haven't had any memory problems, but I'm not dealing with 20k ... >> End Sub ... >> With the above example, after you close the form2 and unload it, if you ...
    (microsoft.public.vb.general.discussion)
  • Re: how to process data when internet connection broken?
    ... keep it in memory using DataSet, but my client don't want to keep recordset ... It is in XML ... >> DataSet) and update the SQL server and local data with the difference. ...
    (microsoft.public.dotnet.faqs)