Optimization

[Ruslan Zasukhin]

On 2/12/05 5:27 PM, "jda" <jda at his.com> wrote:

Hi Jon,

> I maintain my own long field that holds the arbitrary order of
> records in a table. The following loop runs very, very quickly in
> V1.x. It is *very* slow in V2 (about 10 seconds for 4200 records).
> 
> Any idea why? Or better yet, ways to speed it up?
> 
>        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.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------