Using PB9 + sql2000, single machine running is normal, but when the program is run in SQL query analyzer is sometimes slow, turn off the program SQL query analyzer immediately running the query results, at the same time in the local site to run this program to access the same database (data sheet), run the program after suspended animation, why?


Don't need to develop a multi-user version?

CodePudding user response:

Program to update or delete SQL statements such as, but not commit or rollback in a timely manner

CodePudding user response:

Haven't used the update and delete statements,
Normal process start stop there, only to a select,

CodePudding user response:

Means that the program after A machine start, in B will not be able to start the machine, very slow the last tip database errors,

CodePudding user response:

A deadlock? In a timely manner to do transaction commit or rollback!

CodePudding user response:

Using SQL event detector, see what your program is executed statement.
1, the connection of the AutoCommit mode changes to False try, as follows: the SQLCA. The AutoCommit=False
2, in the select, update, insert, delete, such as SQL behind the increasing commit;

CodePudding user response:

Program in do not update, should be set the sqlca. The autocommit=true

CodePudding user response:

Program not feign death, is you kill
Ha ha