32 bit Primary Key lengths - Any real benefits?

fbnewtz · #1 (**permalink**) 09-29-06, 13:18

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

Pat Phelan · #2 (**permalink**) 09-29-06, 13:42

32 bits is the "stock" size of an integer on most machines today. It is the easiest datatype for most languages to handle.

-PatP

loquin · #3 (**permalink**) 10-03-06, 14:03

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.

bogdanco · #4 (**permalink**) 10-10-06, 15:54

The benefit is that you don't run out of numbers

Most updated programming languages have 64bit data types now

Internet Services

Web Development

Digital Marketing

Consumer Tech