Benchmark Comparisons

Last Post 04 Jan 2007 01:30 AM by SQLUSA. 5 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
speakwrite
New Member
New Member

--
02 Jan 2007 09:37 AM
Does anyone know of any reference material that outlines the benchmarks for connecting to MSSQL server via
    Microsoft SQL Native Driver
    ODBC
    JDBC
    any others


My scenario is Win2k3 R2 Server, SQL 2000 with ColdFusion MX7 installed.

ColdFusion uses their own JDBC connector for MSSQL.

I want to be able to show the performace advantages for using the Native MSSQL Server drivers in dotNET 2.0 over ColdFusion. If you can't tell, don't like ColdFusion :-

Any help is greatly appreciated.

SQLUSA
New Member
New Member

--
02 Jan 2007 03:37 PM
My guess is that Native is the fastest.

Let us know.

Kalman Toth DB, DW & BI Architect, SQL Server Training
URL: http://www.sqlusa.com/order2005grandslam
The Best SQL Server 2005 Training in the World
sanjayattray
New Member
New Member

--
03 Jan 2007 07:31 AM
I always found ODBC being the slower and OLEDB being the faster. my first choice would be OLEDB else native and then ODBC. never tried JDBC.
SQLUSA
New Member
New Member

--
04 Jan 2007 01:30 AM
Confirmed. ODBC is reputed to be slow.


Kalman Toth DB, DW & BI Architect, SQL Server Training
URL: http://www.sqlusa.com/order2005grandprix
The Best SQL Server 2005 Training in the World
SQLUSSR
New Member
New Member

--
10 Jan 2007 10:51 PM
What is JDBC? Does that have anything to do with Java? Should upgrade to SQL Server 2005 and use SQL Native Client Interface.
SQLUSA
New Member
New Member

--
13 Jan 2007 01:28 AM
The reason that benchmark is not readily available may have something to do that architecture has more of a determining factor with performance than the choice of a driver.

If you want to take advantage the new features of SQL Server 2005, you have SQL Native Driver.

Kalman Toth
URL: http://www.sqlusa.com
You are not authorized to post a reply.

Acceptable Use Policy