Field.value speed

[Ruslan Zasukhin]

On 3/29/05 6:58 AM, "Kem Tekinay" <ktekinay at mactechnologies.com> wrote:

> 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.

Hi Kim,

How many fields are selected in cursor?

If you can try reduce fields number.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]