MySQL Forums
Forum List  »  General

Re: Optimised way to search over 2 milllion poi data in mysql
Posted by: newbie Shai
Date: September 02, 2014 02:11AM

Dear Rick,
Thank you understand my idea in full but looks like is not efficient. So back to your idea. How should I do the partitioning now? I know you need a particular id for that. Presently I have all my data in one big table with over 2 million records. So are you saying I should have big table and then partition into smaller tables? I am a bit not too clear with the partitioning process? My lat and long is in this form ready 5.42328,100.30737. So taking this example you want me to transform my lat into (5.42328 / 90 * 32767) and long (100.30737 / 180 * 32767).

Options: ReplyQuote


Subject
Written By
Posted
Re: Optimised way to search over 2 milllion poi data in mysql
September 02, 2014 02:11AM


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.