Performance reading field().value

[Thomas Flemming]

Hi Ruslan,

> We have start develop that feature as I have promised.
Any news on this?
Sorry, but I just cant wait to work with the real speed of valentina :-)

Tom




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

-- 
/****************************************
**   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!
***************************************/