Slow updaterecord loop

[Ruslan Zasukhin]

On 4/21/05 7:47 PM, "jda" <jda at his.com> wrote:

> Hi Ruslan,
> 
> I'm using this loop to maintain a sequential integer field, "hit"
> 
>      i = 1
>      result = myCursor.firstRecord
>      while result = true
>        myCursor.LongField("hit").value = i
>        myCursor.updateRecord
>        i = i + 1
>        result = myCursor.NextRecord
>      wend
> 
> I find that it takes 20 seconds or more to go through about 1900
> records (each with 61 fields, if that matters).
> 
> Is there something I can do to speed this up?

Make cursor with one field only

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