Re: sytem wide unique keys

Article View: borland.public.interbase.replication

Article #624

Back to borland.public.interbase.replication Previous Next

#624

From: Craig Stuntz
Date: Fri, 25 Jan 2002 18:16

18 lines
1592 bytes

In article <3c5163fa_1@dnews>, kestas@kompera.lt says...
> is there any tehnique to create system wide unique keys using generators ?

	Yes, you can use offsets.  Generators in a dialect 3 DB are 64 bit 
integers, so you have plenty of space to work with.  Imagine you have 
two locations, A and B.  Set the generators at A initially to 0, and at 
B set them to a trillion or so -- whatever will be safe over the 
lifetime of your app.

	HTH,

	-Craig

-- 
 Craig Stuntz (TeamB) � Vertex Systems Corp. � Columbus, OH
     Delphi/InterBase WebLog: http://delphi.weblogs.com
     InterBase PLANalyzer (Free IB optimization tool):
          http://delphi.weblogs.com/IBPLANalyzer

Technical Details

Message-ID: <MPG.16bb6b1b3b85305798976b@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news-x2.support.nl!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews

References: <3c5163fa_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: f89d7,6a5bf8f7572401b9
X-Google-Attributes: gidf89d7,public
X-Google-ArrivalTime: 2002-01-25 10:20:30 PST
From: Craig Stuntz <cstuntz@no_spam.vertexsoftware.com>
Newsgroups: borland.public.interbase.replication
Subject: Re: sytem wide unique keys
Date: Fri, 25 Jan 2002 13:16:52 -0500
Message-ID: <MPG.16bb6b1b3b85305798976b@newsgroups.borland.com>
References: <3c5163fa_1@dnews>
Organization: Vertex Systems Corporation
X-Newsreader: MicroPlanet Gravity v2.60
NNTP-Posting-Host: 208.235.151.194
X-Trace: dnews 1011982470 208.235.151.194 (25 Jan 2002 10:14:30 -0800)
Lines: 18
X-Authenticated-User: cstuntz
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news-x2.support.nl!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews

Reply to Parent Message