有多少数据源可以冷融处理 [英] how many datasources can coldfusion handle

问题描述

我们有一个带有2个实例的冷灌装企业服务器。每个实例对一个MSSQL服务器上的数据库有200多个数据源。这个数字将继续增长。现在似乎对单个数据源的请求变得越来越慢，即使数据库很小。

We have a coldfusion enterprise server with 2 instances. Each instance has 200+ data-sources to databases on one MSSQL server. This number will keep on growing. Now it seems that requests to a single data-source are getting slower even though the database is small. It is possible that requests get slower when CF has more data-sources?

推荐答案

数据源是否由于某种原因而被分区客户/客户等）？如果这真的只是一个大型应用程序与一堆数据库，您可以通过跨数据库查询通过单个CF数据源减少DSN的数量。

Are the datasources partitioned for a reason (e.g. different clients/customers, etc)? If this is really just a big application with a bunch of databases, you may be able reduce the number of DSNs through cross-database queries through a single CF datasource.

如果帐户CF正在使用连接到SQL Server具有对服务器上两个数据库的读取访问权限，您可以这样做：

If the account CF is using to connect to SQL Server has read access to both databases on the server, you can do something like this:

选择字段1，字段2，字段3。 。
FROM [databaseA]。[dbo] .Table1 T1
JOIN [databaseB]。[dbo] .Table2 T2 ON ...

SELECT field1, field2, field3... FROM [databaseA].[dbo].Table1 T1 JOIN [databaseB].[dbo].Table2 T2 ON ...

我已经做到这一点与州和国家表在多个DB共享。请仔细设置权限，以防止损坏或错误更新。

I've done this with State and Country tables that are shared across multiple DBs. Set the permissions carefully to prevent damage or errant updates.

这篇关于有多少数据源可以冷融处理的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！