admin
Immortal
Immortal

addData() benchmarks


I just did some benchmarking of Jon's change to commit the
measurement data in batch rather than one at a time:

http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3213

Old code:

38055 metric data points in 186426 ms (4.89ms/metric)

New code:

32882 metric data points in 118316 ms (3.59ms/metric)

So, roughly 36% faster. Note that my tests were done with a local
instance of postgres, so the big win (fewer roundtrips to the
database) was not captured here. The speedup is probably much higher
with remote instance due to the network latency.

-Ryan






0 Kudos
0 Replies