MySQL Forums
Forum List  »  GIS

Re: Geospatial search in MySql – different options
Posted by: Joost
Date: January 01, 2007 05:35PM

I'm really interested in the best solution here..

I've done the same thing.. (option 4) but this isn't very fast since you have to do something like:
select * from locations where zipcode in (zipcode_a, zipcode_b, ..)
and this is slow (for me) and does not start using an index.

Solutions would be really appreciated! Please post ANY information!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Geospatial search in MySql – different options
4685
January 01, 2007 05:35PM


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.