Hey Everyone, This is more of a performance question. We have a client in the securities industry for which we have built a client management system in CFML, that enables our securities client to create fully managed database solutions for each of their downstream clients. Due to regulations in the securities industry, our client is required to maintain seperate databases for each of their downstream clients. To date our CF server had about 150 data sources the main applications references, depending on which downstream client is logging in.
Has anyone bumped into an upper limit of DSNs permitted in Cold Fusion? Our client is getting ready to expand and add another 200 clients, and we are a little concerned if CF is going to work well for this since there are no dynamic DSNs. Also, has anyone run into anything in the Microsoft SQL Server side about having that many different connections to the DB server? Technically we run 3 web servers load balanced for this client, so we are really talking about 3 x 150 clients, or 450 connections to the SQL server, growing to probably 900 in a year. Thoughts? Cheers! JB ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307143 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
