MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: Primary key performance int vs. char
Posted by: Ingo Strüwing
Date: August 03, 2005 01:39AM

Yes and yes. :)

int(2) does not use less space than int(11).
In your case it would be optimal to use TINYINT.
See reference manual 11.2. Numeric Types.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Primary key performance int vs. char
6963
Mark Rigney
July 26, 2005 08:47PM
Re: Primary key performance int vs. char
27937
Jay Pipes
July 27, 2005 12:16AM
Re: Primary key performance int vs. char
7489
Ingo Strüwing
July 27, 2005 05:26AM
Re: Primary key performance int vs. char
6366
Mike Connell
August 02, 2005 08:13PM
Re: Primary key performance int vs. char
5668
Ingo Strüwing
August 03, 2005 01:39AM


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.