listed in different place please see
http://forums.mysql.com/read.php?24,287034,287034#msg-287034
Hi, I am interested in designing a Geocoded Location Cache. At present we perform a look up for every position from an external source which is proving to be extremely restrictive and costly.
All the locations are stored in the database as gpsPosition >> lat lng geocodedLocationId.
I was thinking of either using QuadTrees in java to build its own cache or indexing the latitude and longitudes in mysql. Note currently 40,000,000 rows in 6 months! We need it to be around about 50meters match. Doesn't have to be amazingly accurate +- 20 meters maybe, so lat lng to meters can be estimated and fixed.
Would 100,000,000 index entries on both lat and lng produce more than 30 results per second?
Also does anyone know about the performance of the Spacial data types functions?
I'm sure this must be something many people have had to solve.
Looking forward to your answers! Many thanks, Dan
Edited 2 time(s). Last edit at 10/22/2009 02:27AM by Daniel Blackhurst.