SELECT lat,lon
FROM geocodes
WHERE ip BETWEEN 1173020467 AND 1173020467 ;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 04, 2005 10:33 PM
To: Brian Dunning
Cc: mysql@lists.mysql.com
Subject: Re: Help optimize this simple find
Brian Dunning
Brian Dunning [EMAIL PROTECTED] wrote on 11/04/2005 10:36:00 PM:
This simple find is taking 4 to 7 seconds. Way too long!! (This is a
geotargeting query using the database from IP2location.)
select lat,lon from geocodes where ipFROM=1173020467 and
ipTO=1173020467
The database looks