Re: MS SQL Server 2005 JDBC Driver Performance Issue

Richard Yeo wrote:
Peter

If you are porting an application particularly one as hard on performance (calls many stored procs per page using JDBC) as ours the performance the application receives from the JDBC Driver and RDBMS combination is very important!

Our test is very valid given the ported DB needs to perform at similar levels. We are testing all areas of performance not just the driver. You can't just test one area. You have to test each link and identify the weak link in the chain which is clearly the JDBC driver.

Just to throw in another opinion: since you're running against different databases not only the driver *implementation* may be the issue but network protocols may differ! Also, did you try out different connection settings? There are actually settings of the JDBC driver (I know for jTDS but I believe this is true for MS as well) that affect performance.

Did you do the comparison test with jTDS yet?

Kind regards

robert
.

Relevant Pages

  • RE: slow connections with jdbc driver and no entry in hosts file
    ... slow connections with jdbc driver and no entry in hosts file ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: JDBC and handling of errors
    ... connect to an SQL Server and execute some stored procedures. ... JDBC driver. ... If I use our MS SQL Server 2000 Driver for JDBC driver as below, ...
    (microsoft.public.sqlserver.clients)
  • RE: MS JDBC Rowset size doubled ?
    ... | I'm a SQL Server DBA, doing some profiling and tuning on a SQL Server ... | database that is being accessed by a JDBC Driver. ... | This is a MS JDBC Driver, running under IBM Websphere access SQL ... | The developers claim they are not adding the asterisk and that SQL ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: jdbc help:sun.jdbc.odbc.JdbcOdbcDriver
    ... > * I have just started JDBC in java. ... The interfaces in java.sql.* are implemented by the provider of the JDBC driver (which ... The provider may be Sun ... ...
    (comp.lang.java.programmer)
  • Re: jdbc help:sun.jdbc.odbc.JdbcOdbcDriver
    ... > * I have just started JDBC in java. ... The interfaces in java.sql.* are implemented by the provider of the JDBC driver (which ... The provider may be Sun ... ...
    (comp.lang.java.help)