Re: MS SQL Server 2005 JDBC Driver Performance Issue

Richard Yeo wrote:
Thanks
We are using TCP/IP with both Sybase and SQL Server

Just to make myself clear: when I said "network protocol" I didn't mean TCP vs. UDP or such but the DB's network prodocol (I believe it's called "TDS" for SQL Server and jTDS page claims that there is at least version 8.1 of it around).

There are very few connection settings for the SQL Server 2005 JDBC driver. We are using all that give better performance.

Did you try different values for "useCursors"? see
http://jtds.sourceforge.net/faq.html#urlFormat

We have done some basic testing with
http://www.inetsoftware.de/products/jdbc/mssql/merlia/
and jTDS and both appear to be a little faster than the Microsoft JDBC driver. we have tested about 4 other drivers which appear to have the same performance as the Microsoft JDBC driver.
We are running extensive testing over the weekend so will hopefully have some scientific numbers on monday.

That's good. Probably a superfluous question: you don't have an application layer firewall in between server and client?

Kind regards

robert

PS: Please don't top post.
.

Relevant Pages

  • Re: Java and SQL Server
    ... I want to write a java program that reads SQL Server tables. ... prompt the users for their user name and password because the ... administrators only allow authentication through Active Directory. ... I need a particular Microsoft JDBC driver? ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Cannot Connect to SQL Server via Microsoft JDBC Driver
    ... I have some problem connecting to SQL Server 2000 through ... Microsoft JDBC Driver locally. ... JDBC]Error establishing socket. ... In my Test connection java code, ...
    (microsoft.public.sqlserver.connect)
  • Getting FOR XML into Java
    ... I have a question regarding the XML support in SQL Server 2005 and the ... new Microsoft JDBC driver. ... InputStreamReader isr = new ...
    (microsoft.public.sqlserver.jdbcdriver)
  • JDBC driver
    ... Does the Microsoft JDBC driver for SQL Server 2000 work with the MSDE? ... Does it use SQL mode authentication? ...
    (microsoft.public.sqlserver.msde)
  • Re: JDBC and ResultSet problem
    ... > FROM CUSTOMERS ORDER BY CUSTOMER_REVENUE DESC ... cursors, where all the rows are cached _in memory_ by the driver. ... behavior you need (see the current implementation of jTDS). ... One more thing you could take into consideration is that SQL Server ...
    (comp.lang.java.databases)
Loading