On Sep 28, Tom Cook quoth:
> [EMAIL PROTECTED] writes:
> > On Sep 27, Rickard Oberg quoth:
> >
> > For our application where we internally create our primary keys we aren't
> > using a database feature to do so.
>
> How do you guarantee that they are unique across server instances?
A GUID algorithm that allows for free-form strings that encapsulate the
host generated on, the process space within that host, a serial number
within that process, the time generated and a random number for good
measure. (And before you ask, yes the time link with the random number
seed has been taken into account, but it really exists there just as a
feel good factor.)
The distributed nature of our application requires that our database not
be monolithic in nature and minimize data overlap. I.e. the space of all
object instances spans several physical systems and databases separated
geographically.
C=)
--------------------------------------------------------------------------
There are no significant bugs in our released software that any significant
number of users want fixed. -Bill Gates, Focus Magazine, Oct 23, 1995
--------------------------------------------------------------------------
Caskey <caskey*technocage.com> /// TechnoCage Inc.
--------------------------------------------------------------------------
"Welcome to the slippery slope, here is your handbasket.
...say, can you work 70 hours this week?"
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
