I have a table which contains person details and their current geo-spacial lat\long. I am using default engine as innoDB Lat\long will be updated constantly through web service. When the user hits very high while updating it takes more time. How to handle this situation to increase the performance of application?
Thanks in advance.