[wp-hackers] MySQL's spatial data support and GeoData in wordpress

Kevin Newman CaptainN at unFocus.com
Fri Dec 17 17:27:32 UTC 2010

On 12/16/10 9:36 PM, Casey Bisson wrote:
> Don't get me wrong, I think you need both a point and a geometry column: one to support searching the data and the other to display the area it represents.
I believe there must be a way to optimize this. I just don't know how I 
would do that.

> Searching for points near a given point should work efficiently, but mysql has to do a lot more work on geometry columns to answer questions like that. I don't have the docs in front of me, but I'm not sure if the distance function works on geometry values (maybe just points).
I'll try some things - I don't think my Distance alternative is working 
right anyway...

Kevin N.

More information about the wp-hackers mailing list