MySQL Forums
Forum List  »  General

Re: Optimised way to search over 2 milllion poi data in mysql
Posted by: Rick James
Date: September 01, 2014 08:04PM

Well, my code does take advantage of partitioning, but by latitude, and in the way described.

The search has a limit that can effectively be used because of the partitioning and the PRIMARY KEY. Even if it must extend the limit, the code is efficient in that it does not scan the entire table, nor even an entire 'stripe' of the table, which is what would happen with a simple INDEX(lat, lng) or INDEX(lng, lat).

Options: ReplyQuote


Subject
Written By
Posted
Re: Optimised way to search over 2 milllion poi data in mysql
September 01, 2014 08:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.