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. ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
