Re: multi user increment
Re: multi user increment
- Subject: Re: multi user increment
- From: Mohapatra Ashish <email@hidden>
- Date: Mon, 06 Feb 2006 18:27:25 -0800
- Thread-topic: multi user increment
Hi Gino
As you require a number that needs to be unique across all instances, you
will have to maintain a number generator out of the WO Application. For this
you may have to rely on a data generator at database level more than WO and
then assign this new number from the database by using generator functions
of DB while inserting in WO EOModels. The same can be alternately done by
auto allocate DB functions at DB level e.g. Triggers on each insert as in
oracle.
If you implement it in WO, the inserts are faster at DB level but if you
implement it from DB, the inserts are slower at DB level. The catch is that
overall in the first alternate you will just experience an overhead of
channel interfacing and retrieving the number from the DB to WO.
Thanks,
Ashish
On 2/6/06 6:27 AM, "Gino Pacitti" <email@hidden> wrote:
> Hi All
>
> Any thoughts on how to address this problem
>
> I have a multi instance app that connects to a single data store.
>
> For any user, across the instances, I need to increment a numerical
> value newly for each new registered user.
>
> This then has to be saved back to the data store and for there to be
> no conflicts with similar values for new registrants...
>
> Any ideas or have I missed something easy here..
>
> Gino
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
> om
>
> This email sent to email@hidden
--
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden