Optimizing distance calculations
Wednesday, November 26th, 2008My brother wrote about calculating distances with PostGIS. I followed up with some suggestions, but WordPress seems to be eating my comments (strip_tags() is mutilating them, stripping anything after a “<”). So I’m following up here.
Most of my first comment got eaten; I went on to optimize the query significantly. It should have a WHERE [...]
