Stan's slow problem

[Ruslan Zasukhin]

On 5/31/06 7:49 PM, "Stan Busk" <maxprog at mac.com> wrote:

>>> Yesterday I made a lot of tests and as a result I am even more
>>> confused than before. Summing the time taken by each query, you get a
>>> very good timing. I removed anything else in the loop and it is still
>>> slow. Seems 99% of the time is wasted on the For...next. Don't
>>> understand it... No calculation there.
>> 
>> A guess.
>> 
>> Don't you use Vfield.Value ?
> 
> This is the table structure:

No, I ask not about Table structure.
But about how you read values:

loop
    curs.Field("xxx").Value = 5            <<< BAD !!!!
    ...
end


loop
    curs.LongField("xxx").Value = 5        <<< GOOD
    ...
end



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