Marco,
I have used similar processes in the past, but also have appended port
number to the beginning of the key. Separating the fields with '*' so the
date and time can also be used as a time stamp rather than duplicate the
same info in the record.
Cheers,
David Murray
*
Learn and do
* Excel and share
http://u2blog.org
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere
Sent: Thursday, April 24, 2008 5:55 AM
To: [email protected]
Subject: [U2] Guaranteed unique sequential keys
What is the most reliable way to generate unique sequential keys without
having to resort to a record on disk updated through readu/write? The keys
don't have to be contiguous but only be sortable in the order in which they
were generated by several phantom processes running concurrently. I'm
currently approximating this using a concatenation of date and time with
millisecondsB but I'm worried about the possibility of two phantoms
generating exactly the same key.
B
Although no collision has been detected so far, I have added an extra check
where after generating the key I first test if a record with that key
exists. If so IB increment and append aB serial number and repeat the test
until aB unique key is found. ItB seems to be working well but I still think
there is a better way to do this.
B
Thanks for any help.
B
Marco.
__________________________________________________________
Sent
from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
