Re: Primary Key generation - size limit
Re: Primary Key generation - size limit
- Subject: Re: Primary Key generation - size limit
- From: Jacky Gagnon <email@hidden>
- Date: Fri, 23 Apr 2004 12:44:42 -0400
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.