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.