Hi, Our environment includes multiple web servers w/ the latest version of ColdFusion MX 7, clustered through a load balancer. Each web server has 800+ dsns pointing to different SQL databases. We have noticed that the ColdFusion administrator is taking a long time to display or verify all datasources and sometimes it even times out. Another problem is that sometimes the neo-query file gets corrupted (for unknown reasons) which results in the deletion of one, or more, or all datasources on the web server.
Is there a specific limit of datasources that a cf server must abide to? Is having hundreds and thousands of datasources a feasible and recommended scenario and why? Has anyone else run into any of these issues and is there any reliable mechanism of fixing/controlling them, or is this something that we have to live with for the time being. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Server/message.cfm/messageid:6073 Subscription: http://www.houseoffusion.com/groups/CF-Server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10
