Using OrderedSets Re: [IDEA] BinaryLink that supports order !!!

[Ruslan Zasukhin]

On 12/24/05 2:31 AM, "Ed Kleban" <Ed at Kleban.com> wrote:

>> ----------------------------------------
>> 3) I can point another advantage, Ed.
>>   When db engine *knows* something more it can do things more smart.
>> 
>> At least you get advantage, that you can develop some Valentina Database in
>> REALbasic, but this feature will work correctly and in the same way in other
>> languages and IDEs. For example Valentina Studio will correctly you show
>> order of records.
>>     
>> Compare to RDBMS. You application know that INDEX field means, and YOUR
>> application have algorithms to work with it. But other apps believe that
>> this is just USHORT column.
>> 
> 
> Yes.  But if you implement BytePtr, MediumPtr, and ShortPtr as we have
> discussed, then not only will my app know it but other V2-savvy apps such as
> Valentina Studio will know it and can take advantage of it as well.

Agree.

> In the
> mean time I can declare these as foreign key links to provide clues to both
> SQL statements that view this as a traditional RDBMS and to applications
> like Valentina Studio.  While in my own code I can use API calls to treat
> these as if the were in fact ObjectPtr fields, and thus gain 100% of the
> performance benefits with additional 25% to 75% storage benefit, plus any
> additional performance benefit that comes from less paging due to smaller
> table sizes.

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