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:[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

Reply via email to