I'm late to the party here, but I seriously question the need for so many datasources...
what's the rationale behind it? I'm confused... is this an provider situation where you have 1000 clients on one box with a DSN each or something? Laterz, J On 8/8/06, Vesko Kehayov <[EMAIL PROTECTED]> wrote: > > 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. -- --------------- ------------------------------------- Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:6106 Subscription: http://www.houseoffusion.com/groups/CF-Server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10
