<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a huge table of millions of records with id, lat, long.<br />
<br />
I am using the havershine formula to search and find records that are near a certain lat,long combination however this takes a lot of time. I have an index on both fields (lat,long) but doesn't seem to do the work.<br />
<br />
I have read that I should use partitioning but I also know that mySQL has introduced some spatial classes.<br />
<br />
Any ideas on which way is the most effective to do this? Also any example would be highly appreciated!<br />
<br />
Thanks a lot!
</div>
</div>


Hello,

I have a huge table of millions of records with id, lat, long.

I am using the havershine formula to search and find records that are near a certain lat,long combination however this takes a lot of time. I have an index on both fields (lat,long) but doesn't seem to do the work.

I have read that I should use partitioning but I also know that mySQL has introduced some spatial classes.

Any ideas on which way is the most effective to do this? Also any example would be highly appreciated!

Thanks a lot!

mySQL and spatial data. How to search?

Hello,

I have a huge table of millions of records with id, lat, long.

I am using the havershine formula to search and find records that are near a certain lat,long combination however this takes a lot of time. I have an index on both fields (lat,long) but doesn&#39;t seem to do the work.

I have read that I should use partitioning but I also know that mySQL has introduced some spatial classes.

Any ideas on which way is the most effective to do this? Also any example would be highly appreciated!

Thanks a lot!

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.