xf_phantom
Well-known member
Is there any special reason why you're using VARCHAR(255 for lat & lng?
I'm curious because i've seen many different types being used ( http://dev.mysql.com/doc/refman/5.7/en/spatial-extensions.html, mediumtext, double, float,..) in different applications
https://developers.google.com/maps/articles/phpsqlsearch_v3?hl=de
I'm helpless because i don't know what to use for my application on mysql side for best performance, that's also the reason why we want to use elasticsearch http://www.elasticsearch.org/blog/geo-location-and-search/ for the search for the search, but this doesn't solve the question for the perfect data type
I'm curious because i've seen many different types being used ( http://dev.mysql.com/doc/refman/5.7/en/spatial-extensions.html, mediumtext, double, float,..) in different applications
https://developers.google.com/maps/articles/phpsqlsearch_v3?hl=de
I'm helpless because i don't know what to use for my application on mysql side for best performance, that's also the reason why we want to use elasticsearch http://www.elasticsearch.org/blog/geo-location-and-search/ for the search for the search, but this doesn't solve the question for the perfect data type
