RE: running out of memory



Can you post a bigger snapshot of your code? It's not clear what you do in
your loop. At what point is the memory exhausted?

"Supertree" wrote:

>
> Hi;
>
> I have to write custom data integrity utilities comparing files with table
> data.
> I've found that looping through an ado recordset will cause memory problems
> if it's a large recordset.
>
> I'm using this sort of syntax:
>
> adoRSdir = adocn.Execute(sSQL, lrecs)
>
> Do Until adoRSdir.EOF = True
> 'this loop is running out of memory
> Loop
>
> How can you monitor if you're going to run out of memory?
> What technique would be better other than narrowing the sql
> querystring result set?
>
> Thanks for your knowledge.
>
> Best Regards;
>
> Todd
>
.



Relevant Pages

  • Re: Fast string operations
    ... > is why people use unsafe code now and then to use pointer arithmetic to ... > loop over arrays without all the unnecessary bounds checking. ... don't return the trimmed string". ... The customer perceives this as a memory leak. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Performance Improvement of complex data structure (hash of hashes of hashes)
    ... Anno Siegel wrote: ... >> Here is the code that I'm using to build up this data structure. ... loop through and increment the ... I know that memory allocation in C is expensive, ...
    (comp.lang.perl.misc)
  • Re: Cost of calling a standard library function
    ... It accesses/reads memory using esi 4 ... > safly move it within the cache, without having to go via ebx. ... try it the same thing on a different earlier CPU, ... should check it out...for "tight inner loop" stuff, ...
    (alt.lang.asm)
  • Re: Restoring a NorthStar Horizon, problems with SRAM board
    ... A-D FDC is a memory mapped IO device so I would expect some behavior ... loop read/write functions - which puts the system into a two instruction ... SRAM on the Vector Graphics Flashwriter video card located at $F000 ...
    (comp.sys.northstar)
  • Re: Fast string operations
    ... worried about string performance. ... > is why people use unsafe code now and then to use pointer arithmetic to loop ... > I'm aware that looping has to occur one way or the other, but with Trim, ... The customer perceives this as a memory leak. ...
    (microsoft.public.dotnet.languages.csharp)