[Openstreetmap-dev] Performance measurment and CSV

SteveC steve at asklater.com
Sun Jan 1 13:24:28 GMT 2006

* @ 31/12/05 09:30:32 PM immanuel.scholz at gmx.de wrote:
> Hi,
> while I was bored waiting for the big party to start, I did some
> performance measurements of the code we currently use to retrieve map
> data.
> For this, I wrote a small ruby script to generate a dataset for the test
> server.
> You will find it in sql/make-random-data.rb
> Using this data, I test the speed of the various steps within map.rb. This
> turned out (the numbers are in seconds):
> dao.getnodes: 0.202771
> dao.getlines: 1.514142
> ox.to_s_pretty: 17.765789
> gc: 0.242098

This isn't averaged, is it? Is this for 10 calls?

ox.to_s_pretty only gets called on non-gzip enabled browsers. I don't
expect it is, but is to_s any faster?

> So its time to either use another XML library, use another platform (no
> ruby :-(  ) or reactivate our discussion about CSV.

Yes, this seems a good argument of either moving to csv or generating
xml with print statements...

have fun,

SteveC steve at asklater.com http://www.asklater.com/steve/

More information about the dev mailing list