Hi, We are currently using the odbcConnect and odbcDriverConnect functions of RODBC package to connect to a DB built on SQL Server 2005. Are there any other packages / drivers/ methodology that may provide a faster connection? Any help or advice would be appreciated. Thanks [[alternative HTML version deleted]]
Yoni Schamroth-3 wrote:> > > We are currently using the odbcConnect and odbcDriverConnect functions of > RODBC package to connect to a DB built on SQL Server 2005. > Are there any other packages / drivers/ methodology that may provide a > faster connection? >Dates back to 1997: for SQL Server http://msdn.microsoft.com/en-us/library/ms811006.aspx Performance of ODBC as a Native API One of the persistent rumors about ODBC is that it is inherently slower than a native DBMS API. This reasoning is based on the assumption that ODBC drivers must be implemented as an extra layer over a native DBMS API, translating the ODBC statements coming from the application into the native DBMS API functions and SQL syntax. .... Microsoft's testing has shown that the performance of ODBC-based and DB-Library?based SQL Server applications is roughly equal. Dieter -- View this message in context: http://n4.nabble.com/RODBC-Any-faster-driver-tp1557296p1557335.html Sent from the R help mailing list archive at Nabble.com.