[OSM-dev] WHODIDIT

Ilya Zverev zverik at textual.ru
Mon Nov 12 12:17:39 GMT 2012


> I tweaked Zverik's WHODIDIT script to speed-up the queries. These
> performance improvements are mainly due to the usage of a spatial 
> index
> in the database.

Did you benchmark it against old version? Is the performance worth 
doubling the index size and using spatial extensions? To my shame, I 
didn't ever assume there were spatial functions in MySQL, and wrote 
around them. To me it looks the speed of queries remained the same 
(considering your server a bit faster than the one it's currently 
deployed on).


IZ



More information about the dev mailing list