Faster geospatial queries in MySQL

Searching a table in MySQL based on latitude and longitude columns.

——————————————————
📚 Learn more about PlanetScale
• Website: https://planetscale.com/
• Docs: https://docs.planetscale.com/

——————————————————

00:00 A point of interest
00:21 Haversine formula
01:00 ST_DISTANCE_SPHERE distance calculation
03:25 Filtering by ST_DISTANCE_SPHERE
04:28 It's too slow
05:11 Bounding boxes
06:55 Using a bounding box
08:10 Adding an index
10:20 Adding a compound index
11:34 A note about POINT columns

——————————————————

💬 Follow PlanetScale on social media
• Twitter:   / planetscaledata  
• TikTok:   / planetscale  
• Twitch:   / planetscale  
• LinkedIn:   / planetscale