Newsgroup provides open source solution to closed source problem?

As indicated in a previous post I posted a question to a newsgroup regarding the poor performance of the Microsoft SQL Server 2005 JDBC driver.

Peter T kindly suggested that we try

http://sourceforge.net/projects/jtds

I was initially a little hesitant to try an open source driver, especially one that claimed to have the fastest performance for SQL Server 2005 and Sybase ASE. However…

With the jTDS driver, SQL Server 2005 managed stored procedure calls at the rate of: 966.88 per second. This is effectively twice that of the Microsoft driver!

And Sybase ASE 12.5.3 managed stored procedure calls at the rate of: 829.18 per second.

We are now going to start end to end testing with the jTDS driver although my preference would be to have a high performing Microsoft driver.

Shame on Microsoft and Sybase for writing such badly performing JDBC drivers!!!

Oh by the way my contact at Microsoft was of no help.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: