• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Primary Key generation - size limit
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.


  • Follow-Ups:
    • Re: Primary Key generation - size limit
      • From: Jacky Gagnon <email@hidden>
References: 
 >Primary Key generation - size limit (From: Jacky Gagnon <email@hidden>)

  • Prev by Date: Re: Date calculation
  • Next by Date: Re: Primary Key generation - size limit
  • Previous by thread: Primary Key generation - size limit
  • Next by thread: Re: Primary Key generation - size limit
  • Index(es):
    • Date
    • Thread