Can you get a test page into production? You might need to find out if its only this stored procedure that is timing out.
Can you run a conventional query that does the same thing and test it? > To: [email protected] > Subject: cf stored procedure question > Date: Fri, 4 Mar 2011 13:21:33 -0500 > From: [email protected] > > > I posted this on CF-talk, so sorry for the double-post, but I wasn't getting > any response there and this is as much a server question as not. > > ---------- > > I have a page with a stored procedure on it. After the stored proc runs, I > have > a database call to set some variables. The variables aren't getting set in > the > database occasionally. It also seems that the stored procedure, before the > variables are set, times out at occasionally, according to the logs. If a > stored procedure times out, > should the rest of the script run? I don't know if that's the cause of the > stored proc is timing out. Maybe the cf page is timing out from the stored > proc > timing out. > > I have no access to the server that is having the problem because it's in > production. > > > thanks for any information. back to googling. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6928 Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-server/unsubscribe.cfm
