Re: improving speed of mysql distance filter
Less than about 20 km, the diff between answers given by Pythagorean & great circle distance formulas is very small, so as a first approximation, at least away from the poles, you could look for small values of sqrt((lat2 - lat11)^2 + (lon2 - lon1)^2).
Google for great circle distance,approximation for more ideas.
PB
Edited 1 time(s). Last edit at 06/29/2006 07:55PM by Peter Brawley.
Subject
Views
Written By
Posted
9598
May 19, 2006 05:27PM
3442
June 17, 2006 02:52PM
3409
June 17, 2006 03:12PM
4887
June 28, 2006 01:40AM
5458
October 05, 2006 09:56AM
3218
June 28, 2006 11:27AM
Re: improving speed of mysql distance filter
3717
June 29, 2006 07:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.