To clarify - if the checkbox for "maintain connections" is unchecked it IS a performance hit. I didn't see anyone suggesting that you remove it. You WANT to mainain connections, you just don't want to restrict the number of connections. You want CF to be able to create enough connections to service the load. The connections are pooled and recycled as needed.
-----Original Message----- From: Sung Woo [mailto:[EMAIL PROTECTED] Sent: Saturday, June 18, 2005 8:53 AM To: CF-Talk Subject: Re: Datasource Setup Question I'll see if removing the connection limitation has any effect. I do have CFMX fully updated (latest SP and hotfixes). I was under the impression that removing maintain connections ends up being a large performance hit -- is this not true? I do have pages taking longer than 10 seconds logged against server.log. I do see some entries, but they are what I expect (we have one reporting page that can take as long as a minute to run). On the day that the crash happened, there were no entries in the server.log for long-running pages. I guess the crash happened so quickly and so suddenly that server.log didn't get a chance to write anything. >in your situation I would probably remove the connection limitations for the >DSN. Do you have CFMX fully updated? We had some issues with 'maintain >connections' set to yes and for our heavy DB based apps we still have it set >to off. What you probably want to look at is your server log in CFAdmin. >Look for long running request messages and focus on those pages for some >tuning perhaps. Make sure you have 'log long running requests' set to yes. > DK ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209913 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54