Re: sequential numbering across more instances
Re: sequential numbering across more instances
- Subject: Re: sequential numbering across more instances
- From: Florijan Stamenkovic <email@hidden>
- Date: Fri, 15 Aug 2008 10:23:53 -0400
On Aug 15, 2008, at 09:55, Ondřej Čada wrote:
Hi all,
I've just bumped into a need to maintain a sequential numbering of
database rows, which are created by more concurrent WO application
instances.
If you just need a unique identifier for a row, you could use the
primary key value easily, so I am guessing that is not what you need.
So, could you elaborate on this a bit? What kind of a sequence is it?
Do the users need to provide values, or can they be auto generated?
In short, what are you trying to do?
Whilst I can think of a number of possible solutions, I'd like to
ask for your experience before implementing one? Strangely enough I
haven't done this yet, and thus can't well estimate the advantages
and disadvantages of different possible approaches (locking, UNIQUE
column, etc...) and their respective gotchas.
Thanks,
---
Ondra Čada
OCSoftware: email@hidden http://www.ocs.cz
private email@hidden http://www.ocs.cz/oc
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40mac.com
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