RE: [PHP-DB] MSSQL functions vs. ODBC functions

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. 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:mmcculli@sykescanada.com] Sent: Thursday, July 11, 2002 10:14 AM To: php-db@lists.php.net 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 mmcculli@SykesCanada.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php