Field.value speed

[Kem Tekinay]

I am doing a side-by-side comparison of the REALdatabase to V4RB 2 and found
something I did not expect: The REALdatabase is faster at pulling values out
of a RecordSet than Valentina is at pulling data from a Vcursor. Or is there
a faster way to do what I am doing?

Here is the scenario: I run a search on a database using SQLSelect and then
loop through the cursor to pull the values out of one field into an array.
Basically, it is no more than a loop that calls field.Value, then
cursor.NextRecord. The code is almost exactly the same in both versions of
my test, but Valentina takes (subjectively) about twice as long. I found
this especially odd since I can use Vcursor.Position with Valentina while I
had to write a wrapper class to handle this for the RecordSet.

Any thoughts on this?

__________________________________________________________________________
Kem Tekinay                                                 (212) 201-1465
MacTechnologies Consulting                              Fax (914) 242-7294
545 Eighth Avenue, Suite 401                          Pager (917) 491-5546
New York, New York 10018                    http://www.mactechnologies.com

To join the MacTechnologies Consulting mailing list, send an e-mail to:
  mactechnologies_consulting-subscribe at yahoogroups.com