MySQL Forums
Forum List  »  GIS

Reverse Geocoder Cache
Posted by: Daniel Blackhurst
Date: October 20, 2009 03:13AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Reverse Geocoder Cache
5355
October 20, 2009 03:13AM


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.