Blood Python wrote: > I'm using CFMX updater 3, iis5, 512mb ram and mysql 4.0.13. > > Should i limit the connections to the datasource in CFMX?
Yes, but it does not work in currently released versions of CF MX. I don't know if it is fixed in the RedSky beta, but you should be able to test that yourself if you join. > There's some > options in the "Advanced Settings" under datasources in Cfadmin. > > - Limit Connections: <checkbox> > - Retrict Connections To: [number] > > I checked the devnet articles and google and i found nothing about it. Is it > a good pratice? What should be a decent number of connections? Suppose you have your database server configured to accept 32 connections at most. You have 10 datasources. One of them is messed up big time, and suddenly there is a query taking 200 seconds on some page. So whenever there is a request for a certain page, there is no free database connection (they are all busy with long running queries). No problem for CF it just opens a new one. But once you hit the 32 open connections, new connections will fail and the site will start throwing errors. But in the mean time, your one datasource that has a problem has crowded out the other 9 datasources as well. For that reason, it is highly recommended to limit the number of connections to a database. In this example, you would limit the number of connections to about 10, so only if 3 datasources are messed up at the same time they will experience crowding out. This scenario is even more important in a hosted environment, because whenever you think you have something foolproof, a better fool will sign up. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
