----- 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/[email protected]/
> 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/[email protected]/
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.

Reply via email to