Re: Slow query

[Rick James]

I can't answer the question without knowing which fields are in which tables. Please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]

Also, add aliases to make it clear in the query:

SELECT  locId, location.city as city,latitude,
       longitude
    FROM  ip2isp
    join  location on ip2isp.location=locId
    WHERE  INET_ATON('x.x.x.x') BETWEEN start
      AND  end;