Hi,

I have a simple users table, i guess the maximum users i am going to have is 300,000.

Currently i am using:

 CREATE TABLE users
 (
         id INT UNSIGEND AUTOINCEREMENT PRIMARY KEY,
         ....

Of course i have many other tables that the users(id) is a FOREIGN KEY in them.

I read that since the id is not going to use the full maximum of INT it is better to use: MEDIUMINT and it will give better performance.

Is it true?

(I am using mysql on Windows Server 2008)

Thanks.