id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
17245	IpAddressField not stored effeciently	harm	nobody	"Django stores {{{IpAddressField}}}  as a string: (mysql {{{ `ip_joined` char(15) DEFAULT NULL, }}})
This is not effecient, and in cases where you have a LOT of these this hurts.

Django should use an {{{ INT UNSIGNED }}} column instead of {{{char(15)}}}. This saves 73% storage. 
(difference between a 32GB ram VPS or a 8GB VPS)


mysql provides some nice helpers for this:
{{{
mysql> SELECT INET_ATON('10.0.5.9');
        -> 167773449
}}}
ref: http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_inet-aton

"	Bug	closed	Database layer (models, ORM)		Normal	duplicate			Unreviewed	0	0	0	0	0	0