Performance reading field().value

[Ruslan Zasukhin]

On 4/11/09 7:24 PM, "Thomas Flemming" <tf at ttqv.com> wrote:

Hi Thomas,

We have start develop that feature as I have promised.
But today I have take a look on your code and say Hmm.

> Dim mTbl As IVTable = mDB.Table("myobjects ")
> 
> For i = 1 to mCursor.count
>     a = mTbl.Field(1).value
>     b = mTbl.Field(2).value
>     c = mTbl.Field(3).value
>     mCursor.NextRecord() 
> Next

So you use VTable or Vcursor ???

 
> And here is the problem, because this takes some seconds for only 100 records
> in the cursor.
> It seems to be the access to a specific Field, which is so slow. Just looping
> through the cursor:
> 
> For i = 1 to mCursor.count
>     mCursor.NextRecord() 
> Next

Here you talk about cursor again.
 
> is still very fast.

Also TIP for you.

    if you have in table e.g. 50 fields,
    but you do cursor using SLECT f1,f2,f3 FROM T
    then such cursor can be iterated 50/3 = 16 times faster
    than Table.NextRecord()



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