Thursday, January 08, 2009

jTDS:useCursors+prepareSQL performance benchmark

I did a performance benchmark based on different
combination of useCursors+prepareSQL, so here is the comparison
result:

Round 1: useCursors\=true;prepareSQL\=3
Measurements Value
Search.do 1507ms
Throughput 28.88hits/sec

Round 2: useCursors\=true;prepareSQL\=2
Measurements Value
Search.do 1597ms
Throughput 28.7hits/sec

Round 3: useCursors\=false;prepareSQL\=3
Measurements Value
Search.do 1488ms
Throughput 29.2hits/sec

Round 4: useCursors\=false;prepareSQL\=2
Measurements Value
Search.do 1446ms
Throughput 29.8hits/sec

so the Winner is useCursors\=false;prepareSQL\=2, and it is suitable for both perf testing and tuning(catch SQL profiler logs).

here is the link of description of useCursors and prepareSQL
http://jtds.sourceforge.net/faq.html#urlFormat

No comments:

Post a Comment