I want to store Geo location for each Address in my MySQL(Innodb) "tblAddress" table and I think I have 2 Options:
1) 2 columns for Each Address: Latitude DECIMAL(10, 8), Longitude DECIMAL(11, 8) 2) One Column for Each Address: GeoLocation POINT
My program need to find all Address that fall under 1 Kilometer Radius from current Location (Mobile Client).
Also below command does not work for me, not sure what I need to have for this.
CREATE SPATIAL INDEX GeoLocation ON tblAddress (GeoLocation);
So what is the suggested approach to store data for faster calculation and retrieval here. Please advise.