Kbase P26190: Progress hangs with hight disk activity to drop Temp-table f
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/06/2003 |
|
Status: Unverified
SYMPTOM(s):
big Temp-table (many records)
exiting a procedure
Progress hangs with high disk activity
CAUSE:
This is an expected behavior. Progress is cleaning the dbi temporary file to remove the temp-table, which scope is the procedure. With hundred thousands records, it takes few seconds, but it takes a really longer time when there are millions records.
FIX:
If it is really necessary to manage that many records in a temp-table without clean time problems, then solution is to use a single user temporary database instead of a temp-table.