Performance - A Guide For Best Practice

Comparing #16 with #17

Revision #17 was created by Y!! Y!! on Feb 5, 2010, 8:36:58 PM.

Fixed typo

Content

[...]
The type of the column for such a numerical ip address must be `INT(10) UNSIGNED`.

So when saving ip addresses as numerical values, you have the benefit of faster selections/sorting and the size of the table will be smaller since `INT(10)` consumes 4 bytes whereas `VARCHAR(15)` consumes at least 16 bytes or more (depends on the used charset).

Note that this only works with ipv4 addresses.

# 2. PHP #

>Info: Some overview description soon...
[...]