I believe it depends on the database your using when it comes to speed.
However if you use the CFQUERY tag you can use the cachedwithin attribute
and cache the recordset so ultimately thats going to make it quicker.
You can use part of the query string to dynamically name the query in order
to cache dynamic queries
I use both depending on the application.
Also CFSTOREDPROC does not handle parameters to well in certain situations,
i.e you have to make sure the order you place the <CFSTOREDPARAM> tags is
the same as the procedure.
HTH?
Alex
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Craig Bowes
Sent: 01 March 2001 00:24
To: CF-Talk
Subject: <CFSTOREPROC>
I was wondering if anyone new if there was any performance advantage in
using <cfstoreproc> over plain old <cfquery>? I know you need <cfstoreproc>
if your stored procedure returns multiple recordsets but is it any faster or
slower?
Thanks,
-Craig
Please reply to:
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
