Fixed Binary[16] Index

[Bart Pietercil]

Hi Stefan,

the method field is searchable just like a normal field.

Maybe this discussion is also of interest for your solution:

http://valentina-db.com/bt/view.php?id=3157

This is already implemented in the 3.6 beta

hth

Bart Pietercil

On 29 Jul 2008, at 22:00, Stefan Von Torklus wrote:

> Yes, I understand this.
> Maybe I'm completly wrong...
> But:
> I have a 16 Byte-Value.
> I split it into 2 ULLValue-Fields. (simple memcpy the first 8 Bytes  
> to the first variable and then memcpy the second 8 Bytes to the next  
> variable)
> I need a fast lookup on both values.
> You said, that maybe it's possible with the method-field, so I only  
> need one index.
> (I need to have a closer look on that)
>
> But how would I search on the MethodField to compare my searchValue  
> (16 Byte) with two 8 Byte Values in the DB? The findXXX-family only  
> allows to search for one I_Value_Ptr. (Don't I need 2 search  
> parameters?)
> Or would it be possible to create a FixedBinary[16]-Method-Field,  
> which then is able to be indexed?
>
> Sorry, i currently didn't have time to try this out, so I ask it  
> without really knowing what I'm talking about ;-)
>
> but thank you very much for help!!
>
> -------- Original-Nachricht --------
>> Datum: Tue, 29 Jul 2008 21:37:49 +0300
>> Von: Ruslan Zasukhin <sunshine at public.kherson.ua>
>> An: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
>> Betreff: Re: Fixed Binary[16] Index
>
>> On 7/29/08 8:18 PM, "Stefan Von Torklus" <stefanvt at gmx.de> wrote:
>>
>>> Yes, this is the information to create it. But I need the  
>>> information to
>>> search on such an Index the API-way... I'll give it a try and maybe
>> write to
>>> the list again ;-)
>>
>> Method are used as fields.
>>
>> So
>>
>>        Vfield.Find()
>>
>> And other methods from FindXXXX family
>>
>>
>> -- 
>> 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]
>>
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina