For other db servers, this may not be the case, but for SQL Server, ODBC is
the fastest method for accessing your data.
Here are some reasons, directly from MS, for using ODBC:
-- While many database vendors support ODBC by using a mapping layer on top
of their proprietary interface, this is not true for Microsoft SQL Server.
For SQL Server, ODBC are "native" interfaces for SQL Server. (In fact, all
current SQL Server TPC-C benchmarks are published using the ODBC interface,
which is strong evidence of the performance of SQL Server's ODBC
implementation.)
( http://msdn.microsoft.com/library/techart/designeff_choose.htm )
--The ODBC driver uses the performance features of SQL Server
automatically. For example, SQL Server stored procedures can be executed
using an efficient procedure call network format. DB-Library uses a
separate set of APIs to send requests in the network format. ODBC uses the
same APIs used for sending nonstored procedure requests and looks for the
standard ODBC "call" syntax to trigger the use of this efficient network
format.
( http://msdn.microsoft.com/library/techart/designeff_choose.htm )
-- Microsoft did a sample application for a PC Week benchmark Web
application (Nile.com) which put their DNA architecture up against other
vendors for a scalability test. The application's data was held in SQL
Server™ 7.0 and accessed through the ODBC API.
( http://msdn.microsoft.com/library/backgrnd/html/nilewp.htm )
Chris
----------------------------------------------
Original Message
From: "CT, Loo"<[EMAIL PROTECTED]>
Subject: Re: ADO vs. ODBC
Date: Fri, 13 Oct 2000 03:54:58 +0800
>Hi! Aymeric,
>
>I am working on some CF application using COM that returns ADO recordsets.
I
>am totally new to this and I am totally no idea how to loop through the
>recordsets. Would your CD_ADO custom tag help? Can I have a copy of your
>custom tag?
>
>Thanks,
>
>Regards,
>Loo
>
>----- Original Message -----
>From: Aymeric Grassart <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, August 04, 2000 10:29 PM
>Subject: Re: ADO vs. ODBC
>
>
>> ----- Original Message -----
>> From: "Patrick Maddox" <[EMAIL PROTECTED]>
>> To: <[EMAIL PROTECTED]>
>> Sent: Friday, August 04, 2000 9:07 AM
>> Subject: ADO vs. ODBC
>>
>>
>> > I am working on a project to where the client wants a CF database
>> > application, however, they are
>> > requesting that I do a ADO connection to the database(sql 7) vs. the
>> typical
>> > ODBC connection that I am
>> > used to doing.
>> >
>> > Does anyone have info on the differences between the two connection
>types.
>> > What's faster, better .... etc.
>>
>> ADO is faster than CFQUERY, the only problem is that converting the
>> recordset into CF query's makes it 10 times slower ; but other than that,
>it
>> should work.
>> I have an alpha version of CF_ADO custom tag, if you'd like a copy, let
me
>> know.
>>
>> blah,
>> Aymeric
>>
>> > and where I might go to get some additional info on this. The site
will
>> not
>> > get huge volumes of hits, maybe
>> > 200 hits on the database at any moment at the very most.
>> >
>> > Thank you.
>> >
>> >
>> > ***************************
>> > Patrick Maddox
>> > Terralogic, Inc.
>> > 540-213-2447
>> > [EMAIL PROTECTED]
>> >
>>
>>
--------------------------------------------------------------------------
>> ----
>> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> > To Unsubscribe visit
>> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
>> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>> the body.
>> >
>>
>>
--------------------------------------------------------------------------
>----
>> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>>
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send
>a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
>
_____________________________________________
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
