Anyone Doing GEO Ip Lookups - GoFuckYourself.com

Adaml2 · 02-01-2006, 11:47 AM

What DB are you using?

I got a db from ip2location for some cam pages and queries are a little slow to say the least..

mysql> SELECT ipREGION, ipCITY FROM IPCITYLATLONG WHERE (ipFROM <= 1109302065) AND (ipTO >= 1109302065);
+---------------+---------+
| ipREGION | ipCITY |
+---------------+---------+
| MASSACHUSETTS | HYANNIS |
+---------------+---------+
1 row in set (6.23 sec)

Aside from being about 70 miles off (good enough for me) I can't add 6 seconds to a page load. I don't really know what kind of times to expect for lookups either, so if you can post up what db you're using and what your times are (roughly) I'd appriciate the help

montythestrange · 02-01-2006, 11:50 AM

check the index on the ipFROM and ipTO columns...

fuzebox · 02-01-2006, 12:06 PM

The default way ip2location does it is ridiculous, I've got a script that imports the csv into a more manageable db schema, and a PHP include with the functions do deal with it. My queries are fast on entry-level hardware... Feel free to ICQ me

Adaml2 · 02-01-2006, 12:23 PM

fuze pimped me

much apprciated man

Validus · 02-01-2006, 12:35 PM

The dat file is faster, or at least that is my experience. I got the Geo IP City DB from Maxmind.

d00t · 02-01-2006, 01:39 PM

ip2location released some new versions just a few days ago too

tical · 02-01-2006, 02:00 PM

u suck adam

02-01-2006, 11:47 AM	#1
Adaml2 Registered User Join Date: Feb 2001 Location: behind a sheep next to a cliff Posts: 77	Anyone Doing GEO Ip Lookups What DB are you using? I got a db from ip2location for some cam pages and queries are a little slow to say the least.. mysql> SELECT ipREGION, ipCITY FROM IPCITYLATLONG WHERE (ipFROM <= 1109302065) AND (ipTO >= 1109302065); +---------------+---------+ \| ipREGION \| ipCITY \| +---------------+---------+ \| MASSACHUSETTS \| HYANNIS \| +---------------+---------+ 1 row in set (6.23 sec) Aside from being about 70 miles off (good enough for me) I can't add 6 seconds to a page load. I don't really know what kind of times to expect for lookups either, so if you can post up what db you're using and what your times are (roughly) I'd appriciate the help

02-01-2006, 11:50 AM	#2
montythestrange Confirmed User Join Date: Jun 2005 Location: NoCal Posts: 184	check the index on the ipFROM and ipTO columns... __________________ If you put instant coffee in the microwave, do you go back in time? DatingGold Rocks!

02-01-2006, 02:00 PM	#7
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	u suck adam __________________ 112.020.756

02-01-2006, 12:06 PM	#3
fuzebox making it rain Industry Role: Join Date: Oct 2003 Location: seattle Posts: 22,038	The default way ip2location does it is ridiculous, I've got a script that imports the csv into a more manageable db schema, and a PHP include with the functions do deal with it. My queries are fast on entry-level hardware... Feel free to ICQ me

02-01-2006, 12:23 PM	#4
Adaml2 Registered User Join Date: Feb 2001 Location: behind a sheep next to a cliff Posts: 77	fuze pimped me much apprciated man

02-01-2006, 12:35 PM	#5
Validus Confirmed User Industry Role: Join Date: Jul 2001 Location: Calgary, Canada Posts: 4,012	The dat file is faster, or at least that is my experience. I got the Geo IP City DB from Maxmind.

02-01-2006, 01:39 PM	#6
d00t Confirmed User Industry Role: Join Date: Sep 2002 Location: In your mind Posts: 3,766	ip2location released some new versions just a few days ago too