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:

>> And now COMPARE:
>> 
>>       ObjectPtr           and              BinaryLink
>> 
>>         1 : M                              1 : M
>>             
>>          SPEED THE SAME
>>          
>>          SPACE on disk THE SAME
>> 
>> But !!!!!
>> 
>> 1) Binary link do not infect Structure of Table.
>> 
>> 2) Binary Link can be easy converted tomorrow into M:M if your customer or
>> you change mind.
>> 
>> 3) IT IS possible for binary link add parameter, that DEVELOPER swear
>>     todo searches only in one direction, then we can even more win
>>     in space AND speed of modification.
>> 
> 
> You'd save in space because you'd only need to create an index for one half
> of the linkTable, not both sides.
> 
> You'd save in speed because...   hmm.  ...because you could eliminate the
> check for finding additional records after you've found the first one on a
> "->1" link.

Speed of MODIFICATION. Add/Delete

Again because only half todo


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