Mark, 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.
Advertising
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 http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server -----Original Message----- From: Mark McCulligh [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 10:14 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MSSQL functions vs. ODBC functions I am not sure if this question has been asked before, If so sorry for asking again. I have a site that the Client is moving from a MySQL db to Microsoft SQL Server. 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 because it is another layer on top of the DB, but I don't know. Mark. _________________________________________ Mark McCulligh, Application Developer / Analyst Sykes Canada Corporation www.SykesCanada.com (888)225-6824 ex. 3262 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
