Microsoft's JDBC Driver for SQL Server Stacks Up Against Competition : Page 2
At long last, a FREE Type 4 JDBC Driver for MS SQL Server 2000.
by Dr. Heinz Kabutz
Jun 7, 2002
Page 2 of 3
The Performance Evaluation I downloaded several Type 4 drivers to compare with the new Microsoft SQL Server 2000 Driver for JDBC. The Microsoft driver is basically an old-ish version of the DataDirect Type 4 driver, so the performance results between the two are quite similar. I tested the drivers by writing some very basic insert and select query code. I purposely avoided "advanced" JDBC functions because when I tried them at least one of the drivers would fail each time. Table 1 shows the test results.
Editor's Note: This article was published in June of 2002. The data in this table reflects conditions as they were at that time.
The important column to look at is Factor Faster Than JDBC-ODBC, which shows how many times faster each driver is than the Type 1 JDBC-ODBC Bridge.
Listing 1 shows the code I used to test the drivers. You can use this test code to compare any other drivers as well. I cannot emphasize enough how important it is to run your own performance tests in a real-world test environment. Depending on what you are doing, the JDBC/ODBC bridge may actually be better than a Type 4 driver. For example, if you measure how fast a driver inserts large amounts of data into a database via the setBytes() method (e.g., 1MB blocks into an Image column), you'll discover that some of the Type 4 drivers are almost 10 times slower than the JDBC/ODBC bridge (see Table 2).
Table 2: Performance Results for Calling setBytes() on 1MB of Data