Slow updaterecord loop

[jda]

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?

Thanks,

Jon