running out of memory
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
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: running out of memory
... Same thing applies but now you are aware that your SQL request may cause ... > your loop. ... At what point is the memory exhausted? ... >> I've found that looping through an ado recordset will cause memory problems ...
(microsoft.public.data.oledb) - running out of memory
... I have to write custom data integrity utilities comparing files with table ... I've found that looping through an ado recordset will cause memory problems ... 'this loop is running out of memory ...
(microsoft.public.data.ado) - running out of memory
... I have to write custom data integrity utilities comparing files with table ... I've found that looping through an ado recordset will cause memory problems ... 'this loop is running out of memory ...
(microsoft.public.data.oledb) - RE: running out of memory
... At what point is the memory exhausted? ... > I have to write custom data integrity utilities comparing files with table ... > I've found that looping through an ado recordset will cause memory problems ... > 'this loop is running out of memory ...
(microsoft.public.data.oledb) - Re: Innovative Systems FPE...
... window so one could loop using one register for copy in/out but I ... suppose you can simply unroll the loop. ... I mean't swap the order of the bytes in the hardware ... would be a graphical memory map, but even then, I usually rotate it ...
(comp.sys.apple2) |
|
