On Sat, 01 May 2010 15:28:46 -0500, mos <mo...@fastmail.fm> wrote: >
> SELECT * FROM `grid`� force index(section) WHERE n > 49.012 AND s < 49.012 > AND e > > 110.0244 AND w < 110.0244; > > It should give you the answer around 0.1 seconds. Give it a try. :-) > > Mike It actually makes it worse by about 12 times!! mysql> SELECT * FROM `grid` FORCE INDEX(section) WHERE n > 49.012 AND s < 49.012 AND e > 110.0244 AND w < 110.0244; +------------+-------------+--------------+-------------+--------------+-------------+--------------+-------------+--------------+-------------+--------------+----------+ | lsd | n | e | s | w | lat | lng | sec_n | sec_w | sec_s | sec_e | province | +------------+-------------+--------------+-------------+--------------+-------------+--------------+-------------+--------------+-------------+--------------+----------+ | 1301001014 | 49.01424023 | 110.02723089 | 49.01062631 | 110.02169300 | 49.01243327 | 110.02446195 | 49.01424026 | 110.02722931 | 48.99978638 | 110.00508118 | AB | +------------+-------------+--------------+-------------+--------------+-------------+--------------+-------------+--------------+-------------+--------------+----------+ 1 row in set (6 min 4.83 sec) mysql> SELECT * FROM `grid` WHERE n > 49.012 AND s < 49.012 AND e > 110.0244 AND w < 110.0244; +------------+-------------+--------------+-------------+--------------+-------------+--------------+-------------+--------------+-------------+--------------+----------+ | lsd | n | e | s | w | lat | lng | sec_n | sec_w | sec_s | sec_e | province | +------------+-------------+--------------+-------------+--------------+-------------+--------------+-------------+--------------+-------------+--------------+----------+ | 1301001014 | 49.01424023 | 110.02723089 | 49.01062631 | 110.02169300 | 49.01243327 | 110.02446195 | 49.01424026 | 110.02722931 | 48.99978638 | 110.00508118 | AB | +------------+-------------+--------------+-------------+--------------+-------------+--------------+-------------+--------------+-------------+--------------+----------+ 1 row in set (33.26 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
