400 IS a lot, unless you are running shared hosting servers, and it still seems like a pretty high density for a single server.
It's certainly a high enough number that very very few people are going to have first hand knowledge of what happens at 500, 1000, ++ DSN's. My GUESS is that there isn't a practical limit. You'll run out of resources to actually have open connections to that many databases before you run out of, say, disk space to store the definitions themselves. It seems you have enough of an edge case to warrant contacting Adobe directly for an answer if you are really concerned about it. On 5/8/07, Ben D. Higgins <[EMAIL PROTECTED]> wrote: > > Hmm. I don't buy that. I've worked with a lot of different venders, > both hardware and software, and their white papers say one thing but in > production expectations are met. I just want to make sure that I'm not > going to hit some limit eventually. Currently I have 400+ DSNs on my > servers. I don't think that's a lot. Does anyone have way more then > that? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277343 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
