Check out http://dev.aylo.com/FusionADO/
And to answer your question, yes the tag (if your query is a select
statement) goes through the ado recordset to convert it into a cf query
recordset. This extra conversion layer makes the tag slower than cfquery
from the overhead incurred, but we plan on focusing the tag to return an
enhanced structure of the recordset (fieldnames, datatype, et. al.)
w00t,
Aymeric.
----- Original Message -----
From: "Patrick Maddox" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 04, 2000 10:28 AM
Subject: Re: ADO vs. ODBC
> Any benchmarks? Any resources to go to to read up on the differences?
Do
> I have to convert ADO outputs to cfquery?
>
> Thanks again.
>
> Patrick Maddox
> [EMAIL PROTECTED]
>
>
> ----- Original Message -----
> From: Aymeric Grassart <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, August 04, 2000 10:29 AM
> 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/[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.
>
> --------------------------------------------------------------------------
----
> 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.
