Re: MS SQL Server 2005 JDBC Driver Performance Issue

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
.

Relevant Pages

  • Re: The argument of God from DNA being code
    ... since code is the type of thing that results from coder and is not ... DNA is code therefore there had to be a coder. ... smoke encodes fire, which means there has to be a coder. ... inanimate matter. ...
    (talk.origins)
  • Re: [ANN] RealThinClient components > preparing the Roadmap for the Year 2006
    ... > scare away potential clients. ... > Doesn't matter at all how good a coder you are..it probably ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Project Ultraviolet: No IRIX?
    ... >> has some capabilities in this matter. ... let me say this; as a coder of some small experience (currently ... JCS ...
    (comp.sys.sgi.misc)
  • Re: combining of triangular meshes
    ... irrelevant triangles means hidden triangles. ... what I want is to trim the two meshes and then combine the result into ... what does it matter how the single mesh is supposed to look like? ... supposed to look like the two meshes combined. ...
    (comp.graphics.algorithms)
Loading