[OSM-dev] WHODIDIT

[Simon Legner]

Hi!

> 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).

I did not perform statistical benchmarks since they are tricky to do due 
to database caching.
However, the »new« script feels to be (much) faster in my area. After 
panning, the whodidit-tiles appear almost immediately:
 
http://simon04.dev.openstreetmap.org/whodidit/?zoom=12&lat=47.25&lon=11.4


A very basic benchmark done right now; time was taken after the 5th 
identical query. I don't know the load of your server right now. Load 
average on dev.osm.org is 1.81 (15 minutes):

$ time curl 
'http://simon04.dev.openstreetmap.org/whodidit/scripts/tiles.php?age=7&bbox=11.13,47.06,11.66,47.43' 
 > /dev/null
real	0m0.201s

$ time curl 
'http://zverik.osm.rambler.ru/whodidit/scripts/tiles.php?age=7&bbox=11.13,47.06,11.66,47.43' 
 > /dev/null
real	1m0.149s


Index size: I think the database size isn't so much an issue right now. 
If it was, I'd tend to restrict the database to say 1/3/6 months and 
keeping the (apparently) fast queries instead of dropping the spatial index.


Cheers,
Simon