relational generators -- Oracle sequences

[brian_matthewsbrian matthews]

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