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

[newbie Shai]

Dear Rick,
So my final index is just this ADD PRIMARY KEY (`poiID`), ADD KEY `lat` (`lat`,`long`). What do you mean by 40K in each lat and long? What else trick can I use beside indexing to avoid full table scan ?

What do you mean by the lookups in the first table will be mostly "clustered" (as a side effect of the choice of PARTITIONing and PRIMARY KEY) ?