Kbase P100168: A SQL-92 Stored Procedure seems to hang when inserting a large amount of records.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/18/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
A SQL-92 Stored Procedure seems to hang when inserting a large amount of records.
A SQL-92 Stored Procedure is taking too much time to insert a large amount of records.
The same INSERT statement is being used repeatedly, but with different values.
The Stored Procedure is using the SQLIStatement class to execute the INSERT statement.
Querying the table which is being updated by using the UNCOMMITTED READ isolation level, shows that records are being inserted.
CAUSE:
The SQLIStatement class is being used which is for one-time execution.
FIX:
Use the SQLPStatement class which is for repeated execution.