• 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: multi user increment
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: multi user increment


  • Subject: Re: multi user increment
  • From: James Cicenia <email@hidden>
  • Date: Mon, 6 Feb 2006 10:30:33 -0600

Most systems for no holes use an array of available numbers. Once you commit that number is no longer in the array, otherwise it stays in and is available for use.

- James Cicenia

On Feb 6, 2006, at 10:18 AM, Helge Staedtler wrote:

oh, I must have overlooked that there was a restriction existing which said
"without any holes". sorry. I would say, that a sequence without any holes
can only be provided by a queuing machanism. I think a timestamp with
milliseconds would do this in 99.99% of all cases. just an idea.


have fun playing around with this.
just my 2 cent.

regards,
helge


Am 06.02.2006 16:32 Uhr schrieb "Guido Neitzer" unter <email@hidden>:

On 06.02.2006, at 16:08 Uhr, Helge Staedtler wrote:

hmm, I would have a look at the primary keys.
those are ensured by EOF and the DB to be unique, so any number
which is
derived from the primarykey (you might e.g. transform an
alphanumeric PK
into a pure number key) should meet your criteria.

No. Primary keys are not guaranteed to be in sequence without "holes". You may use a stored procedure or something like that to increment a counter - beware of rollbacks.

If there is no requirement for a real sequence without holes, pk may
work. Or, depending on the database, any mechanism that can be used
for integer pk generation.

cug

--
Momo was there and joined in, that was all, but for some reason her mere
presence put bright ideas into their heads. -- from Michael Ende's "Momo"


Expect and Respect.


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40jimijon.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
References: 
 >Re: multi user increment (From: Helge Staedtler <email@hidden>)

  • Prev by Date: Re: multi user increment
  • Next by Date: Re: command line EOF + WOContext
  • Previous by thread: Re: multi user increment
  • Next by thread: Re: multi user increment
  • Index(es):
    • Date
    • Thread