> 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277346 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
