On Thu, Apr 24, 2008 at 4:06 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > I have been storing points in mysql without use of the spatial > extension. I do not forsee the need to ever store more than points, > and am wondering if the spatial extensions would offer any significant > advantages. I have looked a bit for tutorials, etc... and have not > found much. > > One feature that I would like is to be able to find all points withen > X distance from of point Y, without doing a table scan. Would the > spatial index (Rtree) be able to achieve this? > > Are there any good tutorials (or heaven forbid, books) that anyone can > suggest? > > Should I go hang out with the cool kids that are using postGIS ;)
I'm going to answer my own question for the sake of the archive. The spatial index would be able to do an indexed search for points within a bounded box on releases as early as 4.1. Take a look at http://dev.mysql.com/doc/refman/4.1/en/using-a-spatial-index.html . -- Rob Wultsch [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
