Subject | Re: [ib-support] Unique ID's for several Databases |
---|---|
Author | Ann W. Harrison |
Post date | 2001-03-03T17:13:53Z |
At 01:35 AM 3/3/2001 +0100, guido.klapperich@... wrote:
answer is to use GUIDs as David Robinson (?) suggested. Another
is to use generators, but preface the generated value with a string
unique to the database. Stick it at the front, rather than the
end to reduce the size of indexes. The archives at mers should
help.
Regards,
Ann
www.ibphoenix.com
We have answers.
>Does anyone knows any literature about this theme, it's veryThe subject has come up on the mers list from time to time. One
>important for me. I know SQL-Server has this feature and I'm sure, I have
>read this article about realizing this in IB.
answer is to use GUIDs as David Robinson (?) suggested. Another
is to use generators, but preface the generated value with a string
unique to the database. Stick it at the front, rather than the
end to reduce the size of indexes. The archives at mers should
help.
Regards,
Ann
www.ibphoenix.com
We have answers.