[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