Level 67
Yes, use the geospatial functions. It's a lot faster using the highly optimized DB engine to do calculations than using php.
2 likes
Aug 11, 2019
3
Level 6
Decimal lat lon vs Geo spatial mysql
Hello, I'm working on a project that collects Lat Lon from mobile devices. Currently I've made it using decimal fields and calculating distance between points on php side (everything works just fine). Is it better to use 'point' field within mysql instead ? What about performance of calculating distances on mysql side using Geo spatial function?
Level 54
I'd go a step further and say use postgres with the postgis extension vs mysql. It's far more mature and a ton of development effort each release is focused solely on performance.
Level 6
Thank you for a hint, I want to make an mvp and than move to cloud (maybe some queue driver)
Please or to participate in this conversation.