I agree with this in most cases. However it is not currently possible to cache oracle stored procs in cf (except by assigning the results to session or application variables). Also on most simple selects I found that the time for processing was faster using embedded cf queries that calling a stored procedure.
This was using oracle 8i on solaris. thanks, Frederic Jon Hall wrote: > If you are concerned about performance, converting cfquery's to stored > procedures is the best way to optimize an application. Even for selects. > > jon > > Stephen Hait wrote: > > >I've been wondering about using stored > >procedures in templates instead of > >embedding queries. Is there a good reason > >for this if the queries are only select > >statements? > > > >Stephen > > > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
