Efficient Distance Querying in MySQL

Aaron Francis looks into querying MySQL with a ST_Distance_Sphere clause — a function to calculate the linear distance in meters between two lon/lat points — in an efficient way. There’s a few things he does there:

  • No unnecessary calculations in WHERE clauses
  • Pre-limiting the set by applying a bounding box
  • Leveraging Generated Columns
  • Using a Spatial Index

Efficient Distance Querying in MySQL →

~

Via Freek

Published by Bramus!

Bramus is a frontend web developer from Belgium, working as a Chrome Developer Relations Engineer at Google. From the moment he discovered view-source at the age of 14 (way back in 1997), he fell in love with the web and has been tinkering with it ever since (more …)

Leave a comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.