Reading this article might help in your situation : http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp#Owners hip
Unfortunately you need to register at this site to read the article :( Jared Clinton NEC Australia -----Original Message----- From: Matt Kornguth [mailto:[EMAIL PROTECTED]] Sent: Thursday, 4 April 2002 1:23 AM To: CF-Talk Subject: Stored procedure - use dbo.? Thought I read/heard somewhere that prefacing the stored procedure name in the cfstoredproc tag with "dbo." would reduce the amount of SQL Server recompiling taking place, e.g.: <cfstoredproc procedure="dbo.procedurename" datasource="dsn"> <cfprocparam ...> <cfprocresult ...> </cfstoredproc> Does anyone have any experience with this from a best practices standpoint? Advantages/disadvantages? Thanks in advance, Matt Kornguth Web Applications Developer BLR ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
