MySQL Forums
Forum List  »  Newbie

Re: 32-bit BIGINT value
Posted by: Rick James
Date: January 11, 2011 09:25PM

A 32-bit system has to work a little hard to simulate 64-bit arithmetic. Before computers expanded from 16-bit to 32-bit, there was an issue of doing 32-bit arithmetic. (That was in the '90s.) Before that was the jump from 8-bit to 16-bit. There were even a few microprocessors in the '70s that were "4-bit".

Will we every go to 128? Already, under the covers, there are datapaths that are bigger than 64-bit. But there is not much need for 128-bit arithmetic in the foreseeable future. Sure, there are always a few situations where big integers are needed, and there is no limit on what someone will need.

64 is enough to do just about anything by count the atoms in the universe.

IP addresses are moving from 32-bit to 128-bit, but you don't "add" them.

MD5 is 128 bits; SHA-1 is 160 bits. Those do need arithmetic to calculate, but it is very isolated.

IEEE-754 Floating point standard (which is used by virtually every computer today) has some 106 (or so) bit temporary results.



Edited 1 time(s). Last edit at 01/11/2011 09:26PM by Rick James.

Options: ReplyQuote


Subject
Written By
Posted
January 11, 2011 04:55PM
January 11, 2011 06:31PM
Re: 32-bit BIGINT value
January 11, 2011 09:25PM
January 12, 2011 03:02PM
January 12, 2011 08:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.