Alex Rivera | Logout

SQL: Is it efficient to use tinyint instead of Integer if my max value is 255?

Asked 2010-07-07T17:54:25.290
13

Lets assume I want to save the count of datagrid rows which can be max. 24 because each row is 1 hour.

To save the row index in the database a tinyint field would be totally enough. But back in my mind I remember slightly that databases are optimized for integers?!

So is it worth to use tinyint?

Edit
Report

1 Answer

2

tinyint

less space is good.

answered 2010-07-07T17:56:42.647

Your Answer