Tiempos en consulta de Geolocalizacion exagerado

[Italico76]

y la SOLUCION que he pensado........ PROBLEMA RESUELTO

SELECT locId FROM CityBlocks WHERE 3193711229 BETWEEN startIpNum AND endIpNum LIMIT 1 lento
SELECT locId FROM CityBlocks WHERE 3193711229 > startIpNum AND 3193711229 < endIpNum LIMIT 1 lento

SELECT locId FROM CityBlocks WHERE 3193711229 > startIpNum ORDER BY startIpNum DESC LIMIT 1 rapidisimo!
y luego verifico que en ese registro 3193711229 < endIpNum (desde PHP)

o...

SELECT locId FROM CityBlocks WHERE (3193711229 > startIpNum AND 3193711229 < endIpNum) ORDER BY startIpNum DESC LIMIT 1

La UNICA DUDA es como uno esta consulta con esta otra: SELECT * FROM CityLocation WHERE locId = $locId LIMIT 1