Gentlepersons: A bump and a few additional data points.
A call to cfusion_dbconnections_flush() seems to clear up the issue, except: a) Macromedia doesn't recommend flushing manually. b) because we have multiple SPs on one page, we'd need to flush after each one to avoid hitting the connection limit with multiple concurrent users. Still doesn't explain why ColdFusion is not automatically releasing the connections. We've tried unchecking Maintain Database Connections and have set the Connection Timeout very low, but neither seems to help as much as not using Stored Procedures at all. I'll also note that most of our Stored Procedures select record sets and return them through REFCURSORS. Many of them return only a few rows (< 10). Thanks in advance for your time. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197994 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
