Slow updaterecord loop

[Claudius Sailer]

Am 21. Apr 2005 um 19:38 Uhr schrieb 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?

why do you use

Ende=myCursor.NumberOfRecords
For i=1 to Ende
        myCursor.CurrentPosition
        myCursor.LongField("hit").value = i
        myCursor.updateRecord
next

this is out of my thoughts. Coding could be alittle bit different. 
Isn't this faster?

bye


Claudius