webmastersmarte
1 post
Aug 08, 2006
5:25 PM
|
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.
|
