jacobson
3 months ago
1189
3
Tips

Decimal lat lon vs Geo spatial mysql

Posted 3 months ago by jacobson

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?

Please sign in or create an account to participate in this conversation.