currently I'm using PostgreSQL/PostGIS for a small spatial project. Last week the project manager asked me if we could migrate to MySQL with Spatial Extension.
I know MySQL but have no experience with the Spatial Extension. I heard that the extension is not very fast and might contain some bugs.
Now my question – is MySQL Spatial extension stable and fast enough to be considered for an online database with about 20000 spatial operations a day?
The operations are just the standard stuff like:
– export to KML
– point in polygon
– overlapping polygon
The database has one GB of spatial data.
Best Answer
Thanks Mapperz, the link helped to get a feeling about the status of the spatial plugin.
http://www.mysqlperformanceblog.com/2013/10/21/using-the-new-spatial-functions-in-mysql-5-6-for-geo-enabled-applications/