How to measure ADO recordset resource "hit"? 
Author Message
 How to measure ADO recordset resource "hit"?


I am considering fashioning a tool
to provide some recordset-like
functionality, for cases where I
only need read-only, forward-only
recordsets.  The reason: to set
the recordset to Nothing as quickly
as possible, to conserve resources.  
I want to open a recordset,
dump its contents into a VBScript
class object as an array, then
immediately close and Nothing-ize
the recordset.  After that, I pull
my data from the array using the
class object's properties/methods.

This of course is only sensible if
I can prove that my new object
requires fewer resources than an
ADO recordset.

How does one measure this?  What I
would like to do is know how much
RAM (for instance) is used by a
read-only, forward-only ADO recordset
with X fields and Y rows?  Then
I could compare this number to my
own object, and determine if I'm
using more or less.

There are actually two numbers I
think I need to discover:
1. How "small" is a recordset object?
2. How "efficient" is a recordset object?

By #1 what I mean is, how much
resources does an empty recordset use,
while sitting idle?  By #2 what I
mean is, when it's loaded with data
and performing repeated .MoveNext's,
how much RAM and CPU power does it
use?  My object will need to beat
these two numbers to be worth my
trouble.  I suspect that because a
recordset has a huge object model,
mine will win on #1.  But #2 is
less certain.

Suggestions?  Has anyone any notion
of how to measure arcane such things?  

- Tom

 Tom Kelleher Consulting, Inc.


*** Sent via Developersdex http://www.*-*-*.com/ ***
Don't just participate in USENET...get rewarded for it!

Sun, 30 Nov 2003 04:05:56 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Save "" in a ADO Recordset

2. "INSERT INTO .." and ADO Recordset

3. *"*-.,._,.-*"* I"LL TRADE VISUAL C++ FOR VBASIC *"*-.,_,.-*"*

4. Using "embedded resources"

5. "Multimedia Resources"

6. "required resource already in use"

7. MS Resource Localization Toolset: "RLTools"

8. Limited "Resources": What to avoid???

9. Changing Language in "Resource File"

10. Changing Language in "Resource File"

11. Help with "Resources"

12. GetObject("","InternetExplorer.Application") fails in Excel VBA


Powered by phpBB® Forum Software