Hacker News new | ask | show | jobs
by bravo_sierra 5719 days ago
Using the Buffer function it does. Then MySQL will utilize the geometry index, rather than scanning the table. Not clear in the docs, but it's there.
1 comments

Do you have an example?
I'm interested as well (really, as someone who uses sphinx for that currently).
Hey, I'm also using Sphinx :)

Also, thing is filtering is not much of a problem as you can use the Haversine formula ... it gets to be a problem if you also want sorting from closest to furthest.