[DDI-SRG] FYI: implementation performance

[I-Lin Kuo]

Hi,

DDI application implementers FYI:

I've been working on a webservice implementation for USGS and I've just done
a performance comparison with another similar project at a different agency.
The other agency uses an approach based on XSLT stylesheets. Between version
1 and version 3 of the other application, they switched from a java-centric
design to an oracle-centric design because they were unhappy with the
performance. We use an approach based on the StAX API.

other agency -- time to output 30000 stations (100MB xml file)

  version 1, java-centric: 4 hours
  version 3, oracle-centric: 20 min

USGS -- time to output 30000 stations (33MB xml file)

  10.5 sec


It's not exactly apples-to-apples because for some reason they output more
xml than we do, and because the USGS benchmark is just running on my
desktop, not a server, but the efficiency magnitude should be apparent. And
no, I haven't left off any decimals -- the average throughput of 3.1MB/sec
is consistent with our previous benchmarks.

-- 
I-Lin Kuo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.icpsr.umich.edu/pipermail/ddi-srg/attachments/20070914/8747c4be/attachment.html