Re: Full Table Scan With Simple SELECT

[Shawn Hogan]

I ended up changing the query from this:

SELECT * FROM geoip WHERE ipFROM <= $ip_long AND ipTO >= $ip_long

to this:

SELECT * FROM geoip WHERE ipFROM <= $ip_long ORDER BY ipFROM DESC LIMIT 1

...and it was able to effectively utilize the index (and sped everything up).

But it seems like a very inefficient hack to me. Potentially getting as many as 1.6M records, then sorting them to make sure you get the first one.

I guess MySQL just can't effectively use indexes on ranged queries on multiple columns?