I don't fully understand connection pooling but we do have maintain connections enabled. We are not a web host. We are an application service provider. Each of our customers has their own database which means unique DSNs. We've run into some issues with the max simultaneous requests but we have a 2 node webfarm to reduce the load on each server.
Ben Higgins -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 5:15 PM To: CF-Talk Subject: RE: CF 7 data source limit > Currently I have 400+ DSNs on my servers. I don't think that's > a lot. Does anyone have way more then that? You may not think that's a lot. I've seen hundreds of ColdFusion servers, but none that I recall with half that many datasources. I don't work in shared hosting environments, though. I suspect that the number of datasources, by itself, is not going to be where you run into problems first. If all those datasources are active, though, and each is configured to maintain connections, I wouldn't be surprised to see problems with connection pooling. This will be more dependent on the specific database servers you're using than anything else, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277353 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
