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:52:10 -0700
It just goes. It is a matter of choosing the appropriate Java type to
hold the size of data that the database stores. You will want to look
at your DB docs and see what will fit in the column type you are using.
On Apr 23, 2004, at 9:44 AM, Jacky Gagnon wrote:
Hi Chuck
Do I need to use databaseContextNewPrimaryKey if i use a long?
Because in documentation, Apple talk about using a simple Integer for
pk Generation by WO...
Thanks
Jacky
Le 04-04-23, ` 12:27, Chuck Hill a icrit :
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.