Monday, March 23, 2009

Mysql spatial extension

I must be the only one around who didnt knew that mysql spatial extension exists... It is a life saver if proximity based search is to be implemented. Without it you would have to calculate lat/lang ranges that are within some distance of base point (was there, you dont want to), which is rather costly operation, not to mention that this stuff allows to tell if points are inside a polygon or whatever, so good to know its out there, wont forget it next time I encounter some google maps/kml related stuff...

Has anyone used it? Performance?