Viewing 4 posts - 16 through 19 (of 19 total)
TheSQLGuru (8/19/2009)
Again, this doesn't mean that it will be more efficient to store/process IP addresses as a char(15) using your methodology, but it is clearly an option worth pursuing IMHO
I...
August 19, 2009 at 11:16 am
TheSQLGuru (8/19/2009)
August 19, 2009 at 9:47 am
TheSQLGuru (8/19/2009)
could you please redo your testing using a char(17) datatype instead of a varchar(17)?
I'm not sure what would be the point since IP addresses (when used as strings) are...
August 19, 2009 at 8:48 am
tdcheek (8/19/2009)
I've always liked storing IP's as binary(4)
I had considered using binary(4) however since bitwise operations cannot be performed on binary, this made integer my final choice.
HansVE (8/19/2009)
August 19, 2009 at 8:41 am
Viewing 4 posts - 16 through 19 (of 19 total)