[freetds] SQL connection question

Andrew Ballard Andrew.Ballard at mail.wvu.edu
Wed May 3 13:36:45 EDT 2006


Hello.  I got my start in PHP with mySQL, but for the last several years
I worked with ASP and SQL Server.  Early in that job, I read about a
difference between performance with the ODBC drivers versus OLEDB in COM
for Windows.  I wrote some simple tests of my own trying to process
records using the ODBC and SQLOLEDB drivers and the SQLOLEDB were faster
by far.
 
Now I'm back in a job that uses PHP on Linux but they are beginning to
move from mySQL to SQL Server.  I see that SQL Server support on *nix is
based on this FreeTDS library.  I don't really know much about database
drivers, but I'd like to know if FreeTDS benefits (or can benefit) from
the same difference that made the OLDEB driver perform so much better
over ODBC.
 
Andrew
 


More information about the FreeTDS mailing list