Difference between #16 and #17 of
Performance - A Guide For Best Practice

Revision #17 has been created by Y!! on Feb 5, 2010, 8:36:58 PM with the memo:

Fixed typo
« previous (#16) next (#18) »

Changes

Title unchanged

Performance - A Guide For Best Practise

Category unchanged

Tutorials

Yii version unchanged

Tags unchanged

Content changed

[...]
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...
[...]
9 5
10 followers
Viewed: 27 873 times
Version: 1.1
Category: Tutorials
Tags: performance
Written by: Y!!
Last updated by: ajsharma
Created on: Feb 4, 2010
Last updated: 13 years ago
Update Article
Revert to #16 | Revert to #17

Revisions

View all history