Kbase P50766: How to speed up the tablemove process?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/01/2011 |
|
Status: Verified
GOAL:
How to improve the performance of tablemove process?
GOAL:
How to speed up the tablemove process?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
The tablemove command runs using a single transaction, so in case of failure it should be capable of an undo.
Since tablemove is a transaction based operation, all adjustments for general performance recommendation are applicable.
Listed below is a summary of them:
. Start the database in multi-user mode, even if the tablemove process will run alone.
. Start APW, BIW to speed up the writes to the database files.
. Tune the BI block size and BI cluster size accordingly.
. Use ?B, -bibufs, -spin, etc
. With a valid backup of the database try the following:
Turn off AI files
Start the database with ?i
IMPORTANT INFORMATION:
WHEN RUNNING WITH THE -i PARAMETER, IF THE LOAD FAILS, YOU MUST GO TO BACKUP!
For other important recommendations on database performance that is applicable also on tablemove operations please refer to Solution The Top 10 Performance Tuning Tips For The Progress Database