Tuesday, October 13, 2009

MySQL GIS Extension

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: