Will it take longer to find a record using Ulong field as record id than using RecID?

[Ruslan Zasukhin]

On 11/26/06 9:53 AM, "Steven Ronald" <stevenrt39 at yahoo.com.au> wrote:

> Ruslan,
> 
>> Aha, so it have play role of ID,
>> I did not realize that.
> 
>> Note, Valentina support this way also. This is pure relational model way. >In
>> the WIKI exists article that compare this ways.
> 
> If I create my own record ids by using a field of type
> ULONG, will it take any longer to locate a record than
> if I use in

YES.

Because Valentina will need search index file on that ID.
With RecID there is no such index.

Joins on recID + ObjectPtr are 4 times faster of ULONG + ULONG


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