Re: multi user increment
Re: multi user increment
- Subject: Re: multi user increment
- From: Helge Staedtler <email@hidden>
- Date: Mon, 06 Feb 2006 17:18:54 +0100
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:
This email sent to email@hidden