It works great for me. After working out the bugs and adding the spatial index I am now searching in the 0.05 second timeframe vs. minutes
otherwise. Dan On Sun, 2 May 2010 23:39:41 -0700, Rob Wultsch <wult...@gmail.com> wrote: >>>> >> >>> On Sat, May 1, 2010 at 11:12 PM, dan <d...@tappin.ca> wrote: >>>> >> >>> >>>> >> >>>> >>>> >> >>>> Can any one help me with understanding the mysql spatial >>>> >> >>>> functions? >>>> >> I >>>> >> >>>> can >>>> >> >>>> only seem to find bits and pieces of how-to's etc. >>>> >> >>>> >>>> >> >>>> I have an existing table of lat / long data representing unique >>>> >> >>>> boundaries >>>> >> >>>> i.e. rectangles and I want to search the table to find the >>>> rectangle >>>> >> >> that >>>> >> >>>> bounds a specific point. >>>> >> >>>> >>>> >> >>>> Dan >>>> >> >>>> > > <troll> > Please at least considered PostGIS. > > In my limited experience all the good GIS people I know use PG. Also > spatial indexes are limited to MyISAM in MySQL, which is a significant > limitation for many users. > > http://postgis.refractions.net/ > > </troll> > > > -- > Rob Wultsch > wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org