Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2006
    Posts
    3

    32 bit Primary Key lengths - Any real benefits?

    I am looking through the SugarCRM database structure and they use 32 bit key lengths. Is that really necessary? Is there any real benefit you get from using such a long primary key?

    Thanks,

    Fred

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    32 bits is the "stock" size of an integer on most machines today. It is the easiest datatype for most languages to handle.

    -PatP

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Quote Originally Posted by Pat Phelan
    is the easiest datatype for most languages to handle.
    as well as most 32 bit processors.

    In the future as data bus widths (and supporting languages) migrate to 64 bits, undoubtedly, 64 bits will become the easiest by default.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  4. #4
    Join Date
    Oct 2006
    Location
    Romania
    Posts
    8
    The benefit is that you don't run out of numbers
    Most updated programming languages have 64bit data types now

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •