I have an app that formerly used PostgreSQL with PostGIS but now the environment changes and I have to use MySql.
In my app i had a database query that searches the nearest point to a point. Note that my table has about 40 Million rows.
SELECT strength, created, updated, point, ST_Distance_Sphere(ST_GeomFromText('Point(:lat :long)'), point) AS distance FROM signalstrengths ORDER BY distance ASC LIMIT 1;`;
I read that mysql can't use postgres' <-> operator and the above query is what I came up with through reading docs and SO.
But this query doesn't work and I'm concerned that the speed of the query will suffer from changing to MySql (from what I've read).
Can you help me fixing that query and tell me more about the speed differences?