Cursor.FindSingleValue

[Thomas Flemming]

Hi Ivan,


 > It means you find a solution.
yes, its fine for now.

 > Just  not  all  the  features  are  implemented  in  ADKs. This one is
 > just considered as not important feature.
It is important (for me), please add, will still speed up this story.

 >> Its funny, but mCur.ToArraySet is almost in zero-time.
 > Not surprising me because it is Valentina :)
:-)


Best Regards and thank you,
Tom




Ivan Smahin schrieb:
> Hello Thomas,
> 
> Tuesday, December 29, 2009, 12:54:04 PM, you wrote:
> 
>> Hi Ivan,
> 
>> ....
> 
>  >> But probably FindIndex() is not implemented for VNET.
> 
>> No, its not.
>> I think, I'm using the wrong language.... :-(
> 
> Just  not  all  the  features  are  implemented  in  ADKs. This one is
> just considered as not important feature.
> 
> 
>> But anyway, iterating through the arrayset works at a reasonable speed.
> It means you find a solution.
> 
>> Its funny, but mCur.ToArraySet is almost in zero-time.
> Not surprising me because it is Valentina :)
>> Only the loop takes time.
> 
> 
>> Private arrayset As VArraySet = cursor.ToArraySet
>> For i As Integer = 1 To arrayset.Count
>>      If arrayset.ItemAt(i) = recid Then
>>          CursorPosition = i
>>          Exit For
>>      End If
>> Next
> 
>  >> The only pitfall is an additional memory for that arrayset.
>> How much for 1 mio records?
> 
> Rougly speeking ~ 10^6 x sizeof(uint32) = 4 MB
> 
> 
> 
> 

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