Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


Performance Aspects of Shadowing


Performance is not noticeably affected by shadowing in multi-user systems, even though the shadowing system needs more machine resources because more files need to be updated.

Applications do not have to wait for the shadows to be updated because this is performed in the background. Actually all updates to the disk, even to master databanks, are performed by background processes (except for updates to TRANSDB and its shadows).

In single-user systems no background process is used. This means that an application has to wait for the shadows to be updated.

Tuning

If the updating of shadows is delayed it will cause TRANSDB to grow. This can happen for several reasons:



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX