ODBC is not inherently slower - it depends if the driver is built as an
abstraction to the native layer or if it bypasses the native layer.   In
addition, a properly written ODBC driver will actually enforce
additional functionality on the back-end database, to further isolate
you from functional lacks.

Also, If you are going to migrate databases and have to change the
database API calls in your script, do yourself a favor and use PEAR:DB
with ODBC - less changes in the future.

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software
Universal Data Access & Virtuoso Universal Server

-----Original Message-----
From: Mark McCulligh [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, July 11, 2002 10:14 AM
Subject: [PHP-DB] MSSQL functions vs. ODBC functions

I am not sure if this question has been asked before, If so sorry for

I have a site that the Client is moving from a MySQL db to Microsoft SQL
Is it better to setup an ODBC connection to SQL Server and use the ODBC
functions OR to use the MSSQL functions.  If I have the choice with is
better or are they about the same.  Logic would say ODBC is slower
it is another layer on top of the DB, but I don't know.


Mark McCulligh, Application Developer / Analyst
Sykes Canada Corporation
(888)225-6824 ex. 3262

PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to