Please, take a look in this article: http://www.ambysoft.com/mappingObjects.html.
You will find some nice stuffs about generate unique ids for objects (and relational databases).

Dufloth.

----- Original Message -----
From: zifnabbe@...
To: ib-support@yahoogroups.com
Sent: Friday, November 09, 2001 4:01 PM
Subject: [ib-support] Generating UniqueID [2]


Thanks all for your information!

I see thus 2 possible solutions to creating unique ID's:

1) using numeric(18,4) or numeric(18,0):

what the difference between these if you look at the generated key as
an INT64? The key is created with GEN_ID(key, 1), does increment with
1, so I guess both are the same if we look at them in function of
unique keys. But in speed numeric(18,4) is slower? Am I correct?

2) Usage of a GUID key:

I see one big benefit in this that even if the database isn't
reachable, you still generate unique ID's on different PC's.

The possible cons:

1. I don't see a way on creating it at the moment on database level,
eg GEN_GUID (I know Oracle has something like that). OR am I wrong
here? Did somebody already made this in a trigger on
Firebird/Interbase level?
2. Slower than using an INT64 key.
3. I suppose it is not OS dependend, or am I wrong here as well?

Somebody who wants to elaborate on this?

Thanks, Tom.


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]