The Daily Parker

Politics, Weather, Photography, and the Dog

More Weather Now improvements

Weather Now v5.0.9194 just hit the hardware, with a new feature that allows you to browse the Gazetteer by finding all the places near a point. (Registration required.) I also added a couple of admin features that I will propagate to every other app I have in production, and made a few minor bug fixes.

Only one minor hiccup: I forgot to add a spatial index to the Gazetteer, which caused searches around a point to take minutes instead of seconds in production. I added the index to the database definition, and after about an hour it had indexed all 15 million locations in the database. So the Nearby Places feature should work perfectly now.

This is one of those things you don't notice in a dev-test environment. The dev-test database only has about 200,000 records in it, so even without the index it only took a moment to find all the places around a point. Nothing like testing in production to find a huge performance miss!

Add comment

Loading