Hi Bruce,
Thanks for your answer.
The paper of Scott Ambler is very interesting and clear.
As you suggested, I'm going to try the HIGH-LOW key.
May be I'll have new questions ...
Have a good day.
Sylvie.
___________________
CREDI RA
Sylvie Palluel
[EMAIL PROTECTED]
___________________
> -----Message d'origine-----
> De�: Bruce Snyder [mailto:[EMAIL PROTECTED]
> Envoy�: mardi 20 juillet 2004 18:54
> ��: [EMAIL PROTECTED]
> Objet�: Re: [castor-dev] [castor-dev]Key generator : best one for large
> tables
>
>
> SYLVIE PALLUEL wrote:
>
> > A little question about the key generator.
> >
> > I'm using the MAX key generator on NUMBER(20,0) for my tables.
> > But is it the best choice for an application which can generates a large
> > number of records each year (approximatevely 2 000 000 for a table)?
> > Some records will be epurated periodiccaly, but the MAX key generator
> will
> > not use the free numbers.
> >
> > I have to use a key generator which is ok with all databases (MysQl,
> Oracle,
> > ...).
> >
> > I've read about UUID key generator. Can this generator be better for my
> > application ?
>
> Sylvie,
>
> Might I suggest that you take a look at the HIGH-LOW key generator. It
> is far more scalable and unique. There are many articles on this style
> of key generator available on the web. I'll send you one offline written
> by Scott Ambler.
>
> Bruce
> --
> perl -e 'print
> unpack("u30","<0G)[EMAIL PROTECTED]&5R\\"F9E<G)E=\\$\\!F<FEI+F-O;0\\`\\`");'
>
> The Castor Project
> http://www.castor.org/
>
> Apache Geronimo
> http://incubator.apache.org/projects/geronimo.html
>
>
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
