[dba-SQLServer]ODBC Connection

Great for coding, automating and moderating OT debates.

Jim

-----Original Message-----
From: dba-sqlserver-admin at databaseadvisors.com
[mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of Arthur
Fuller
Sent: Tuesday, February 11, 2003 3:46 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]ODBC Connection


Two new UDFs for the dbaLibrary :-)
BOD() beginning of debate
EOD() end of debate

Arthur

-----Original Message-----
From: dba-sqlserver-admin at databaseadvisors.com
[mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Jim Lawrence
(AccessD)
Sent: February 11, 2003 6:24 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]ODBC Connection

Hi Julie:

An ODBC connection may seem like a simple method to get connected to a SQL
database. There is a price to pay and that is in performance. At one time
when I was still debating whether to use an ODBC connection or go directly
to ADO-OLE. A simple test set the course. The result was as follows: ODBC
downloading 10,000Plus records a report, 20 minutes...ADO-OLE 1.3 seconds.
End of debate.


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com