Re: Primary Key generation - size limit
Re: Primary Key generation - size limit
- Subject: Re: Primary Key generation - size limit
- From: Chuck Hill <email@hidden>
- Date: Fri, 23 Apr 2004 09:27:14 -0700
java.lang.Long valueType l
On Apr 23, 2004, at 8:48 AM, Jacky Gagnon wrote:
Hi,
By default WebObjects use Integer for storing PK. Integer have a max
value of 231-1. In other word the limit is not infinite, especially
when record are deleted regularly from a table (gap are created because
some primary key value are lost, not reused by WO).
Whats the best stategy in this case, if I don't want to reach this
limit?
-Using a bigger number (long) or binary keys (24 bytes).
-Trying reusing objects (vs deleting these objects) to avoid gaps in
keys generation.
-Trying to avoid gaps into pk generation algorithm.
If you can point me to some documentation or case studies about
strategies in pk generation...
Thanks!
Jacky :-)
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.