Re: Optimised way to search over 2 milllion poi data in mysql

[newbie Shai]

Dear Rick,
Is it possible to go with out using partitioning. The problem in our scenario is that we want to find the nearest point with out bothering how far the location is. So maybe a particular partition might not contain it then another one may contain so it fails to gives us any results.

My idea is first to scope say the lat and longitude between +2 and -2 if this fail then make it bigger say +4 and -4. Keep growing till we find one location. So any optimization idea here?