IP address and Country

[kee nethery]

When we did this, the database table had a start and end IP address range column.

The IP addresses were entered into the table as integers without the dots. I’m not sure but I think we might have put a “1” at the beginning of the IP address integers so that everything stayed 13 digits (ie the front zeros in an IP address were not eliminated).

StartIP and EndIP columns were indexed.

The lookup time was pretty quick. 

Kee Nethery