Re: MS SQL Server 2005 JDBC Driver Performance Issue
- From: Robert Klemme <shortcutter@xxxxxxxxxxxxxx>
- Date: Fri, 04 Aug 2006 16:14:44 +0200
fundba wrote:
Starting with the disclaimer that I'm a DBA looking for answers and not a coder with a solution, I'll mention what sent me here and see if it meshes with this issue...
We are also running the SQL 2005 driver against SQL 2000 (build 2187) and we have found that no matter WHAT you do (based on available info), straight stored procedure calls are still packaged and delivered as prepared statements so we 'lose' all of the benefits of RPC. I suspect we are losing 15-30% in dearly needed throughput because of this.
look for paramter "prepareSQL"
http://jtds.sourceforge.net/faq.html#urlFormat
Maybe that can be used for tweaking.
robert
.
- References:
- Re: MS SQL Server 2005 JDBC Driver Performance Issue
- From: fundba
- Re: MS SQL Server 2005 JDBC Driver Performance Issue
- Prev by Date: Re: MS SQL Server 2005 JDBC Driver Performance Issue
- Next by Date: Re: MS SQL Server 2005 JDBC Driver Performance Issue
- Previous by thread: Re: MS SQL Server 2005 JDBC Driver Performance Issue
- Next by thread: Re: MS SQL Server 2005 JDBC Driver Performance Issue
- Index(es):
Relevant Pages
|
