Patrick,
ADO still uses ODBC or OLEDB. Ado is just another layer that odbc
talks to.
Cf database interaction is fast but there are some advantages using
ADO like,
"You can do server side processing of data, before you send it down
to the client."
This reduces the over head of bringing all the data across the
wire (Ado uses server side cursors for this).
I have seen CF hang on to memory while bringing down the data
and CF doesnt
release the memory, instead it resuses it. Asp , Odbc and asp
work in hand with IIS for this.
Well, i guess you could achive the same functionality uses
Stored procedures in your
database. But CF has its own advantages of rapid development.
sooo goes the story...
Joe
----- Original Message -----
From: "Patrick Maddox" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 04, 2000 10: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.
> 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.
