PB9 and Oracle10G development project, the database USES the direct way, the development environment are on the same machine, the system login is slow, takes 80 seconds to open the login screen, after login system, operation soon, (they login, please brothers under the guidance of Daniel, thank you.)

Direct script is as follows:
//connect to the database directly with constant
SQLCA. DBMS="O90 Oracle9i (9.0.1)"//use the DBMS is 9 version but 10 also available so no change,
The SQLCA. LogPass="database1_pwd"
SQLCA. ServerName="former"//this is tnsnames. The connection string of the ora file
The SQLCA. LogId="database1"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="PBCatalogOwner=database1"

CodePudding user response:

Sqlmonitor with the program

CodePudding user response:

The login code has a relationship with you, how do you mark messagebox various points, and then see which code is the slowest, may be a logged in user check process will retrieve the log,

CodePudding user response:

Application of PBL is overmuch, can also cause the program to move line starts slowly