Re: 2 column between optimization

[Brad Culberson]

+------------+
| version() |
+------------+
| 4.1.13a-nt |
+------------+

CREATE TABLE `geo_feature` (
`latitude` float default NULL,
`longitude` float default NULL,
`feature` varchar(50) default NULL,
KEY `GeoFeatureLocationBoundingBox` (`latitude`,`longitude`),
KEY `GeoFeatureLatitude` (`latitude`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8


| Table | Non_unique | Key_name | Seq_in_index | Column_name
| Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------------+------------+-------------------------------------------+--------------+---------------------------------
--+-----------+-------------+----------+--------+------+------------+---------+
| geo_feature | 1 | GeoFeatureLocationBoundingBox | 1 | latitude
| A | 239523 | NULL | NULL | YES | BTREE | |
| geo_feature | 1 | GeoFeatureLocationBoundingBox | 2 | longitude
| A | 2155714 | NULL | NULL | YES | BTREE | |
| geo_feature | 1 | GeoFeatureLatitude | 1 | latitude
| A | 239523 | NULL | NULL | YES | BTREE | |


For this optimization, We need to pull all the data in a certain bounding area by lat/lon thus the following query:

Select * from geo_feature where latitude BETWEEN .06494 and 0.7384 and longitude between -1.234 and -1.1212;

also tried:

Select * from geo_feature where latitude > .06494 and latitude < 0.7384 and longitude > -1.234 and longitude < -1.1212;

Thanks,
Brad