View Single Post
Old 02-01-2006, 11:47 AM  
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
Adaml2 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote