Kbase P12165: When killing a JDBC or ODBC process while it is in the middl
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/01/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
When killing a JDBC or ODBC process while it is in the middle of a large delete, the delete takes at least 3 times as long as it would normally
problem happens with SQL-92 clients (JDBC, ODBC. etc)
FIX:
1. SQL-92 client starts a transacation, the message gets sent to SQL-92 server
to process
2. SQL-92 server processing the transaction, no communication (this is
important) between the client and the server happens until the transacation is
finished
3. When the transacation is done, server trying to reach the client and find out
the client is gone
4. Server trying to back out transacations (undo the delete), which is at least
as expensive as delete