Kbase P110536: Performance problem right after an online Probkup
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/11/2005 |
|
Status: Unverified
SYMPTOM(s):
The first query after an online Probkup is very slow
The same query is 10 times faster when it has been run a couple of times
CAUSE:
The reason is that the database buffer is flushed during the Online backup. All used records are replaced by non used records in the buffer.
FIX:
A workaround to increase the performance could be to directly run the query in batch mode in order to populate the database buffer with used records.