Thanks! I bookmarked this page since it contains interesting
information.

--- In ib-support@y..., "Marcos Vinicius Dufloth" <dufloth@t...>
wrote:

> 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@u...
> To: ib-support@y...
> 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]