relational generators -- Oracle sequences

[brian_matthewsbrian matthews]

Hi all,

my Oracle sequence stats memory was sadly lacking, which a weeks leave has 
revived.

My Oracle training notes tell me that a sequence is good up to 10^27. This 
means that the example below is good for not 100 years but - wait for it - 
100 thousand billion years ! (roughly)

I had recalled 2^27 rather than 10^27. Thanks to those that corrected me ( 
offline ), but why not question this on-line, is this not what a discussion 
gruop is all about ?

One other point, the comment below '( admittedly as yet unsupported )' 
should have read '( admittedly as yet unreproducable )'.

Bri,


>From: "brian_matthewsbrian matthews" <brian_matthews_bmw@hotmail.com>
>To: powerh-l@lists.sowder.com
>Subject: RE: relational generators -- Oracle sequences
>Date: Tue, 13 Jul 2004 20:32:32 +0000
>
>thanks all,
>
>it seems that we already have sequences in our (pre PHweb) Powerhouse app 
>and they work like a dream.
>
>Our real concern is that the PHweb architecture might suffer the same ( 
>admittedly as yet unsupported ) issues that our Axiant 'Guru' assures us 
>exist with axiant thin clients when accessing Oracle for next key 
>processing. Unfortunately, we do not yet know if these Axiant problems 
>include sequence processing ( we are planning on using Axiant for our 
>internal users).
>
>Extra thanks to Peter for the remark on 'monitoring for sequence maximums'. 
>We had averaged that it would take 100 years for an Oracle sequence to max 
>out - assuming 100 users creating 100 new records per minute ( stats purely 
>from memory ). Of course, once we are web enabled, who knows what hit rate 
>to expect.
>
>Which brings me to my next question for Bob, namley, can you give us any 
>stats on maximum hit rates per PHwebserver per box and/or ideal 
>configurations of PHwebservers per box ? We are going with either HPUX or 
>windows - even the crudest rates would give us something to go on
>
>more thanks, Bri
>
>
>>From: "Peter Bateman" <pfbcs@hotmail.com>
>>To: powerh-l@lists.sowder.com
>>Subject: relational generators -- Oracle sequences
>>Date: Tue, 13 Jul 2004 15:00:23 -0300
>>
>>Brian:
>>
>>If I had to move this code to Oracle. I would try to create an Oracle 
>>sequence
>>for each unique value of item.
>>
>>You access a sequence in a manner similiar to accessing a table. If 
>>PowerHouse
>>gives you trouble you could put the access in an Oracle  view.
>>
>>This saves having to program lock the record and increment the counter.
>>
>>You should test that the counter is not nearing the maximum value.
>>
>>
>>
>>Regards,
>>Peter Bateman
>>
>>_________________________________________________________________
>>Add photos to your messages with MSN Premium. Get 2 months FREE*  
>>http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
>>
>>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>>Mailing list: powerh-l@lists.sowder.com
>>Subscribe: "subscribe" in message body to 
>>powerh-l-request@lists.sowder.com
>>Unsubscribe: "unsubscribe <password>" in message body to 
>>powerh-l-request@lists.sowder.com
>>http://lists.sowder.com/mailman/listinfo/powerh-l
>>This list is closed, thus to post to the list you must be a subscriber.
>
>_________________________________________________________________
>It's fast, it's easy and it's free. Get MSN Messenger today! 
>http://www.msn.co.uk/messenger
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to 
>powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.

_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! 
http://www.msn.co.uk/messenger