Optimization

[jda]

>       i = 1
>  >        result = myCursor.firstRecord
>>         while result = true
>>           myCursor.LongField("hit").value = i
>>           myCursor.UpdateRecord
>>           i = i + 1
>>           result = myCursor.NextRecord
>>         wend
>>         myCursor = nil
>>
>>
>>  Thanks,
>>
>>  Jon
>>
>>  P.S. If it matters, the cursor was made with kNoLocks:
>>
>>  myCursor = myDatabase.SQLSelect(query, EVCursorLocation.kServerSide,
>>  EVLockType.kNoLocks)
>
>And it have one field only ?
>
>May be we pool all fields of table...
>Igor, you need check this.
>

No, it has many fields.

Actually, the speed is worse than I said. It turns out it take 10 
seconds for only 1433 records. So it really is very slow. In V1.x it 
was virtually instantaneous.

Jon

P.S. Making the cursor kReadWrite did not help.