本次要给客户作一个演示，所以环境都是临时搭建的。具体环境如下：DB：Oracle9i, 内存：512M，xpsp2cognos：cognos8.3，内存：2G，xpsp2，硬盘：WD3200AAJS-08L7A0数据：主表2......
Tip: Type the command ulimit -a to determine the currently assigned values for Transformer. The time, file, and memory settings should show a value of unlimited.
----------------------------------------------------------------------
Recommendation - Optimize Gateway Settings for Series 7 IQDs 数据库连接优化
To further shorten the data read phase for Series 7 IQDs, you can change the database-specific settings found in the gateway .ini files included in the Transformer installation directory.
Search for a file name such as cogdm*.ini, where the asterisk represents a specific database version. The entries in each gateway .ini file are different, depending on the database type.
Note: For Cognos 8 data sources, see the Cognos 8 Architecture and Deployment Guide.
Example - Change Oracle Database Settings
Oracle uses the cogdmor.ini gateway file for database-specific settings. We recommend you consider adjusting the following settings:
Fetch Number of Rows
Increasing the number of rows to fetch in each fetch operation can improve performance on some systems. Although the current limit for this number is 32767, numbers larger than the default (100) may degrade performance on some systems.
Fetch Buffer Size
Increasing the size of buffer used during fetch operations from the default (2048 bytes) can improve performance on some systems.
Where both entries have
4/4 首页 上一页 2 3 4 |
