BO 6.5 performance

[jennyfher]

Hello:
WE just upgraded to BO 6.5 and the reports performance have been very poor compare to the previous 6.1 performance, We have checked the DB side an everything seems to be runnig fine there. ANy ideas on what to check on the BO side. Thanks

 

[jennyfher]

In case any of you find this problems. Here is the infor I have. After upgarding to BO 6.5 we were having performance problems and some of the things we found in our investigation: 1) There is know bug for BO 6.5 were the client is sending a lot of uneccesary messages to the server; this was known for unix, so we found it for windows. BO is working on a hot fix for this.
2) BO was not closing the session in the database, even hours after the client was disconnected. BO is working on this as well

 

[skrandel]

We resolved your 2nd issue by doing 2 things. In the CS.CFG file (connection server), we changed the "Max Pool Time" to 0. We did this in 2 places. Then we made sure that all our connections were defined to "Disconnect after each transaction". The combination of these 2 virtually eliminated the INACTIVE connections.

Steve Krandel
VERITAS Software