MySQL GIS Extension tutorial.
Lets you add a special column for your latitude/longitude data tables - geometry. Then you create an index on that column called a spatial index. This is really an R-Tree index that is very fast when you’re doing range queries.
You want to use MySQL's GIS because spatial indexes are faster for latitude/longitude range queries than regular indexes.
No comments:
Post a Comment