Kbase P9127: Performance recommendations for BussinessObjects accessing Progress database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
Performance recommendations for BussinessObjects accessing Progress database
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
Progress 9.1D
FIX:
There are 3 things to do when using Business Object (BO) And Progress SQL92:
1- Make sure to use Progress 9.1D with service pack 1 (client side and server side)
2- Create all the statistics required on the database when using it for the first time and re-create them for all the tables in which new data was loaded. Please ensure to execute the following statements:
- UPDATE statistics
- UPDATE INDEX statistics
- COMMIT
3- To get Business Object working in the most efficient way, please check out the following URL:
http://www.actuate.myweb.nl
At the bottom of this page there is information on how to set up BO and Progress SQL92 in the most efficient way. There is a word document and a zip file containing detailed information.