注册 留言板
当前位置:首页 > 企业级应用 > Informatica > 正文

Slow access to Repository while non-administrative users attempt listing of labels in PowerCenter

来源:INFOCOOL   发布时间: 2017-06-17   作者:网友   浏览次数:
摘要: Slow access to Repository while non-administrative users attempt listing of labels in PowerCenter Problem Description ...
Slow access to Repository while non-administrative users attempt listing of labels in PowerCenter
Problem Description
In PowerCenter, while the non-administrative users attempt to list labels, it takes more than five minutes to show the results. Access to Repository is slower.
If the user has administrative privileges, then the listing is much faster (it takes less than one minute).
Cause
This issue is due to the number of labels existing in the Repository (probably in the order of a few thousand) and the privileges check done for each single label before allowing any non-administrative users to access them.
For each label, there is a single query fired against the Repository Database. Even though the Database is very responsive, the user has to wait for those few thousands of queries to be executed.
Solution
The slowness is linear to the number of labels and the time each query takes to return from the Database.
The only way to reduce this time is by keeping the number of labels low and clean them frequently.
Applies To
Product(s): PowerCenter

Last Modified Date:6/16/2017 5:32 AMID:ID:507692
People who viewed this also viewed
HTML File
ERROR: "CheckInfaHome[6]: test: argument expected INFA_HOME is not correctly./../" while running setinfa9logs on HP-UX installations in PowerCenter
HTML File
UM_10094: The Service Manager failed to update privileges for group <group> in security domain <security domain name> for service <service name>. The service users and groups are not synchronized with the domain.


我来说两句
评论内容:
验  证  码:
 
(网友评论仅供其表达个人看法,并不表明本站同意其观点或证实其描述。)
评论列表
已有 0 条评论(查看更多评论)
精彩专题
  • 本月排行
  • 总排行
友情链接:
QQ交流群:①群 155252576 INFOCOOL官方交流群 ②群 469193068 WEB前端技术交流群 ③群 531831996 数据库交流群 ④群 243504572 编程技术交流群
设为首页 - 加入收藏 Copyright @2016 Infocool 版权所有 粤ICP备16000626号