Using Binary Link or Object Pointer?

[Ruslan Zasukhin]

On 9/6/07 9:07 PM, "Dave Parizek" <david at parizek.com> wrote:

> But for speed on 1:M selections, binary link is faster than objectPtr??
> a lot faster??

No Dave,

Even optimized 1:M BinaryLink will NOT win 1:M ObjectPtr.
They will be equal by speed and size.

BinaryLink M:M between tables T1 and T2,
  YES - will win join of e.g. Person and Phone tables,

Because using BinaryLink we need only one join,
Using ObjectPtr or FK links we need 2 joins.

As I remember:

    ObjectPtr is 4 times faster on join of FK

    MM BinaryLink will win 2 times than
        MM Table with 2 ObjectPtrs.

    MM BinaryLink will win 2*4 times than
        MM Table with 2 FK.
    


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