Sets from Cursors Re: VCursor.AddRecord

[Ruslan Zasukhin]

On 12/2/05 7:52 PM, "Ed Kleban" <Ed at Kleban.com> wrote:

> Ruslan has just added bit_and & friends which can now be used do blindingly
> fast genetic searches on a gazillion records to find the 1% that most likely
> have the candidates you care about.  But you still have to weed through all
> those candidates.  You could write a far more complex query in SQL that
> would eventually get the job done and return fully qualified matches.
> Alternatively you could write a loop that manually traversed over each
> record returned in the cursor and apply whatever logic you'd like written in
> the native development language.  But I'm guessing that there is a large
> class of sophisticated conditional checks you might want to do for which by
> far the most efficient tool to weed these out is some variation of:
> 
>   aVBitSetOfRecsIwant = FindXxxx( withinVBitSetFromCursor ... )

TIP:

If you KNOW that you will find few records (1%)

Then it is better use ArraySet.

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