Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Appl. Performance degraded after upgrade from PB7.0.2 to PB11.5.1

Status
Not open for further replies.

mucnivasun

Programmer
Aug 17, 2009
3
US
Currently, we have our applications in PB7.0.2, connecting
to Oracle 10g database( using native driver 'O84 ORACLE
v8.4' + Oracle 9i client).
SQLCA.DBMS = 'O84 ORACLE v8.4'
SQLCA.LogID = gs_userid
SQLCA.LogPass = gs_userid
SQLCA.ServerName = gs_connectstring
SQLCA.AutoCommit = FALSE
SQLCA.DBParm = 'PBDBMS=1'
CONNECT using SQLCA;

We have upgraded the application to PB11.5.1 and connecting
to same Oracle 10g database (using native driver 'O10 ORACLE
10g' + Oracle 10g Client).
SQLCA.DBMS = 'O10 ORACLE 10g'
SQLCA.LogID = gs_userid
SQLCA.LogPass = gs_userid
SQLCA.ServerName = gs_connectstring
SQLCA.AutoCommit = FALSE
SQLCA.DBParm = 'PackageProcs=1'
CONNECT using SQLCA;

After upgrading, the application performance is degraded
drastically. Is there any option to improve the performance or PB will have this much (400% time delay) after upgrade? Please help us on solving the issue.

Regards,
M.Srinivasan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top