It's true? performance issue

Question

I heard somewhere that you must have fields of type int in front of all the other types in your tables. They said the request is faster or something else. It's true?

For example -

• id int (10)
• int time (11)
• user_id int (10)
• title varchar (128)
• text text

... instead of:

• id int (10)
• title varchar (128)
• text text
• int time (11)
• user_id int (10)

Answer 1

, , , . MySQL , . MySQL ,

MyISAM, (VARCHAR, TEXT BLOB), . , , . . 13.1.3, " MyISAM ". , VARCHAR CREATE TABLE ROW_FORMAT = FIXED.

Answer 2

. , , () - ( ): , , , .

Answer 3

MySQL, , , - , RDBMS , , .

, , . , , , , , id (x bits)something(y bits)+date(z bits), id: s , 0... x z, y + z , .

, , , , (= ) .

Answer 4

, , : , .

, , int ? , int , (, GUID), int - , GUID . , , int , int ( - ).