RE: UUID's

["Richard Jackson" <richardjackson@xxxxxxxxxxxxxxxxxx>]

No, your test is fine.  I was worrying about performance when you get a UUID
from somewhere off the box.  I think that 500 per second is pretty good
unless your design uses unique identifier keys incorrectly - not necessarily
your fault but definitely your problem if it happens to you.

Richard Jackson
Richard Jackson and Associates Ltd.
IBM Business Partner
mailto:richardjackson@richardjackson.net
http://www.richardjacksonltd.com
Telephone: 1 (303) 808-8058


-|-----Original Message-----
-|From: owner-midrange-l@midrange.com
-|[mailto:owner-midrange-l@midrange.com]On Behalf Of John Taylor
-|Sent: Friday, November 10, 2000 11:22 AM
-|To: MIDRANGE-L@midrange.com
-|Subject: Re: UUID's
-|
-|
-|Thank's to all who helped with GENUUID(). It's working great!
-|
-|Richard,
-|
-|With respect to the latency warning, are you referring to potential
-|performance bottlenecks, or a risk of duplicate ID's?
-|
-|Your warning did get me thinking, so I decided to run a crude
-|little test. I
-|created a PF with a single field to store the UUID value, and no primary
-|key. I then created a program that called GENUUID() and wrote a PF record
-|with the result, for 5000 iterations. The program was submitted to three
-|different subsystems (jobs held) and all three were released
-|within a second
-|of each other. It took about 8 seconds for all jobs to complete.
-|Finally, I
-|did an ADDPFC TYPE(*PRIKEY) in order to test for uniqueness. Everything
-|worked just fine.
-|
-|Do you think my test was too simplistic?
-|
-|
-|John Taylor
-|Canada
-|
-|----- Original Message -----
-|From: "Richard Jackson" <richardjackson@richardjackson.net>
-|To: <MIDRANGE-L@midrange.com>
-|Sent: Friday, November 10, 2000 07:04
-|Subject: RE: UUID's
-|
-|
-|> beware of latency - you may need them very quickly.
-|>
-|> Richard Jackson
-|> Richard Jackson and Associates Ltd.
-|> IBM Business Partner
-|> mailto:richardjackson@richardjackson.net
-|> http://www.richardjacksonltd.com
-|> Telephone: 1 (303) 808-8058
-|>
-|
-|
-|+---
-|| This is the Midrange System Mailing List!
-|| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
-|| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
-|| To unsubscribe from this list send email to
-|MIDRANGE-L-UNSUB@midrange.com.
-|| Questions should be directed to the list owner/operator:
-|david@midrange.com
-|+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---