Performance reading field().value

[Thomas Flemming]

Hi Ruslan ,

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

no, I'm using Vcursor , sorry, its wrong only in this email.


> 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()

This is interesting, I didnt know this.


Best regards,
Tom


> 
> 
> 

-- 
/****************************************
**   Dipl.-Ing. Thomas Flemming
**   Software Development
**
**   Touratech AG
**   Auf dem Zimmermann 7-9
**   D-78078 Niedereschach
**
**   mail  tf at ttqv.com
**   fon   +49 (0) 7728 9279-206
**   fax   +49 (0) 7728 9279-29
**
**   http://www.ttqv.com
**   http://www.touratech.de
**
**   ... und immer dem Pfeil nach!
***************************************/