• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: sequential numbering across more instances
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
  • Follow-Ups:
    • Re: sequential numbering across more instances
      • From: Ondřej Čada <email@hidden>
References: 
 >sequential numbering across more instances (From: Ondřej Čada <email@hidden>)

  • Prev by Date: sequential numbering across more instances
  • Next by Date: WOBuilder substitute for Eclipse 3.3+ in Leopard
  • Previous by thread: sequential numbering across more instances
  • Next by thread: Re: sequential numbering across more instances
  • Index(es):
    • Date
    • Thread