Hello,
On 07/25/2002 02:34 PM, Andrew Hill wrote:
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.
The truth is that ODBC is insufficient and does not seem to be useful to
completely isolate you from having to handle many database differences
in your PHP database applications.
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.
This is another issue, but the truth is that PEAR:DB ODBC driver is very
weak (read pratically useless for database independent development)
precisely because ODBC API does not provide information or functions to
deal with the underlying database in a independent manner.
Maybe you should try developing real database independent applications
with it so you can have a real picture of how frustrating it can be.
Regards,
Manuel Lemos
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]
--
Regards,
Manuel Lemos
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php