Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Stored Procedures vs CFQUERY
- Thread starter ice7899
- Start date
- Thread starter
- #3
stored procs are faster than the equivalent queries
however, i don't think you can cache the results of a stored proc (unless you do so yourself in session variables or summat)
that's the great thing about cached queries -- coldfusion doesn't call the database at all during the cached period, and not calling the database at all is way faster than any stored proc is ever going to be
r937.com | rudy.ca
however, i don't think you can cache the results of a stored proc (unless you do so yourself in session variables or summat)
that's the great thing about cached queries -- coldfusion doesn't call the database at all during the cached period, and not calling the database at all is way faster than any stored proc is ever going to be
r937.com | rudy.ca
- Status
Similar threads
