Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jean-Sebastien Carle Storing IPv4 Addresses for Performance RE: Storing IPv4 Addresses for Performance
HansVE
Mr or Mrs. 500
Points: 524
More actions
August 19, 2009 at 6:16 am
#1041434
I store these as four tinyint columns. Also uses just four bytes but is human-readable, does not require all your conversions, has implicit validation, and better meets the 1NF goal of atomicity.