Searching in a cursor

[Ruslan Zasukhin]

On 8/9/06 6:34 AM, "Carsten Friehe" <rblists at online.de> wrote:

Hi Carsten,

> Thank you for your fast answer!
> 
>>    you need remember in your current record
>>    field name value AND its RecID.
> 
> Ok, that is no problem!
> 
>> In new cursor you do binary search of this name.
>> This is fast. 20 jumps for 1000 records. 30 jumps for million records.
> 
> What do you mean by "binary search"? Is this something I can do with
> Valentina directly?

No, you need write binary search algorithm in your RB code.
It is 10-15 lines of code only
 
>> May happens that you will find few records with the same name.
>> Then INSIDE of this small group you do linear search by RecID
> 
> That will happen, but this is faster than all records!

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