专业化管理 > 配置您的 Windchill 环境 > 使用 Windchill Configuration Assistant 配置 Windchill > 配置一览 > 手动计算 WTPrincipalCache 大小
  
手动计算 WTPrincipalCache 大小
手动计算 WTPrincipalCache 大小的步骤
要手动计算 WTPrincipalCache 大小,请按如下所述步骤进行操作:
应使用缓存大小计算公式 (3*A)+(2*B)+C+(2*D),其中:
1. A 是系统中活动用户的数目 (disabled=0)。
2. B 是用户定义组的数量 (status='public' 和 disabled=0)。
3. C 是系统组的数量 (status='system' 和 disabled=0)。
4. D 是系统中活动组织的数目 (disabled=0)。
计算 WTPrincipalCache 大小时需要考虑以下几点:
WTPrincipalCache 的值应大于 A、B、C 和 D 的和,以避免数据库查找。
当 A+B+C+D 与当前 wt.cache.size.WTPrincipalCache 设置接近时,请考虑根据 (3*A)+(2*B)+C+(2*D) 公式增加 WTPrincipalCache 值。
生成结果的查询如下所示:
1. 对于 Oracle:
select sum(Total) from (
select exp(sum(ln(Total))) as Total from (select 3 as Total from dual union all select count(*) as Total from WTUser where disabled=0) union all
select exp(sum(ln(Total))) as Total from (select 2 as Total from dual union all select count(*) as Total from WTGroup where lower(status)='public' and disabled=0) union  all
select count(*) as Total from WTGroup where disabled=0 and lower(status)='system' union all
select exp(sum(ln(Total))) as Total from (select 2 as Total from dual union all select count(*) as Total from WTOrganization where disabled=0)
);
2. 对于 SQL Server:
select sum(wtp.Total) from (
select exp(sum(log(wtu.Total))) as Total from (select 3 as Total union all select count(*) as Total from WTUser where disabled=0) as wtu
union all
select exp(sum(log(wtg.Total))) as Total from (select 2 as Total union all select count(*) as Total from WTGroup where disabled=0 and lower(status)='public') as wtg
union all
select count(*) as Total from WTGroup where internal=1 and disabled=0  and lower(status)='system'
union all
select exp(sum(log(wto.Total))) as Total from (select 2 as Total union all select count(*) as Total from WTOrganization where disabled=0) as wto
) as wtp;