If you use @USERNO, instead of the pid, it will be OS independent. Tom Whitmore
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Thursday, April 24, 2008 6:58 AM To: [email protected] Subject: Re: [U2] Guaranteed unique sequential keys Marco Manyevere wrote: > 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. Assuming unix, add the process id to your key. So if you're currently using internal_date*internal*time, add *pid. There's a GCI interlude to get the process id, I *think* it's GETPID, but you'll have to look that up. If you're on windows, this won't help you much. -- Allen Egerton aegerton at pobox dot com ------- 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/
