Tinyint better to use or not

I have a question. Is tinyint better to use or not with a 64 bit OS. The Paging on this would be of 64 bit and not 8. And thus tinyint will consume same memory as int(4 byte). How does it actually makes a differen开发者_开发问答ce?

Its for all language or db.

---

I think the best answer to performance questions like these is

Measure. Don't guess.

1. Choose one or more dbms. (They don't all work the same.)
2. Build a mock-up of your database using tinyint.
3. Build another mock-up using integers.
4. Load both with sample data.
5. EXPLAIN and EXPLAIN ANALYZE queries on both databases.

Come back and tell us what you found. (You might be surprised.)

---

of course a tinyint is faster / smaller than a bigint.

smaller datatypes allow more pages per row, the data is smaller.. indexes are smaller.

it's a BIG deal.