stored proc is definately faster because everytime you use cfquery, the sql inside the tag has to be interpreted to the language the dataserver understands...with cfstoredproc this step is skipped.
At 06:42 PM 1/29/2002 -0500, you wrote: >Do not know about speed, but access to output parameters and the >ability to >trap an error (i.e. detect that an error code was returned) are in >themselves worth it. > >Justin > > > -----Original Message----- > > From: Steven Durette [mailto:[EMAIL PROTECTED]] > > Sent: Monday, January 21, 2002 11:01 PM > > To: CF-Talk > > Subject: Re: CFStoredProc vs CFQUERY > > > > Thanks for the info, does anyone know if one is faster than the >other? > > > > Steve > > ----- Original Message ----- > > From: "Shawn Grover" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Monday, January 21, 2002 8:29 PM > > Subject: RE: CFStoredProc vs CFQUERY > > > > > > > Use the CFPROCRESULT name="MyQueryObject" inside the CFSTOREDPROC > > > tags > > > (normally the last one specified)... > > > > > > Using cfstoredproc tags eliminates a bunch of errors - in > > the CFQuery > > > call, > > > how do you know the Date is a proper format? the cfprocparam tags > > > handle > > > any neccessary conversion (within reason) for you. > > > > > > Also, with cfstoredproc, you can have multiple recordsets > > returned, and > > > have > > > access to the Stored Procedures return value. You can't do > > that with > > > CFQuery. > > > > > > Shawn Grover > > > > > > -----Original Message----- > > > From: Steven Durette [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, January 21, 2002 6:15 PM > > > To: CF-Talk > > > Subject: CFStoredProc vs CFQUERY > > > > > > > > > I was just wondering if any one knew the difference between the > > > following: > > > > > > <CFSTOREDPROC PROCEDURE="usp_myproc" DATASOURCE="mydatasource">> > > ><CFPROCPARAM TYPE="IN" CFSQLTYPE = CF_SQL_DATE VARIABLE= >FOO > > >> > > dbVarName = @param2>> <CFPROCPARAM TYPE="IN" CFSQLTYPE >= > CF_SQL_INTERGER VARIAB= > > > > > > BAR dbVarName = @param3> > > > </CFSTOREDPROC> > > > > > > AND THIS: > > > > > > <CFQUERY Name="qryMyQuery" DATASOURCE="mydatasource"> > > > {CALL usp_myproc("01/23/1971", "31")} > > > </CFQUERY> > > > > > > Also, when the stored procedure returns a query, how would > > you access > > > it > > > through the first method? The second method at least allows you to > > > name > > > the query so that you can access the resulting recordset. > > > > > > Thanks, > > > > > > Steve Durette > > > Database Administrator/Web Developer > > > Engineering/Construction System Support > > > SBC/Ameritech > > > > > > > > > > > > > > > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
