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
Thursday, January 08, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment