Binary links Re: Question Backlog for Valentina mailing list.

[Ruslan Zasukhin]

On 11/16/05 11:25 PM, "Ed Kleban" <Ed at Kleban.com> wrote:

>> But yes in Valentina 2 you can use FOREIGN KEY now, it works as link,and it
>> have constraints. So in general you loose nothing here.
> 
> You say "lose nothing here", and in terms of functionality I agree.  What I
> have not seen you state clearly yet however is that "Because of the way
> links are implemented in Valentina, if you use say a single-byte or
> short-word key field and use as a relation link to a recId, then the
> performance is just as fast as if you had used and ObjectPtr."
> 
>     Question:  Is that the case?  Or is there a performance penalty for
> using foreign key fields in this manner?

I remember that join on FK is slower than on ObjectPtr.
Because it needs jump into Key field.


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