Re: Slow query

[Dragos Gabriel Iancu]

mysql> explain 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\g
+----+-------------+----------+--------+-----------------------------------------------+-------------------+---------+---------------------------------+--------+--------------------------+
| id | select_type | table    | type   | possible_keys                                 | key               | key_len | ref                             | rows   | Extra                    |
+----+-------------+----------+--------+-----------------------------------------------+-------------------+---------+---------------------------------+--------+--------------------------+
|  1 | SIMPLE      | ip2isp   | range  | start,end,idx_start_end_loc,idx_loc_start_end | idx_start_end_loc | 4       | NULL                            | 685619 | Using where; Using index |
|  1 | SIMPLE      | location | eq_ref | PRIMARY                                       | PRIMARY           | 4       | transfer_ro_pre.ip2isp.location |      1 | Using where              |
+----+-------------+----------+--------+-----------------------------------------------+-------------------+---------+---------------------------------+--------+--------------------------+
2 rows in set (0.02 sec)

mysql>

This is my result.

Now it looks good. Thanks you very much.



Edited 4 time(s). Last edit at 02/14/2011 10:04AM by Dragos Gabriel Iancu.