Kbase P131366: Binary dump of a particular table is slow
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/10/2008 |
|
Status: Verified
SYMPTOM(s):
Binary dump of a particular table is slow
Process seems to stop for a few seconds and then continues
A 18.3 GB table dumps faster than a 1.4 GB one
Table has a high fragmentation scatter factor
FACT(s) (Environment):
Table resides in a RAID 5 disk
Progress 9.x
OpenEdge 10.x
CAUSE:
The scatter factor affects the performance of the binary dump since it has to read data blocks scattered all over the disk.
FIX:
To reduce the scatter factor and make the binary dump faster, perform the following steps:
1) Create a structure file with the new area extents (preferably on a non RAID 5 disk)
#
# addarea.st file
#
d "TMP Area",32 /db/otherdisk f 1048576
d "TMP Area",32 /db/otherdisk f 1048576
d "TMP Area",32 /db/otherdisk f 1048576
d "TMP Area",32 /db/otherdisk
2) Create the new area in the DB
prostrct add sports addarea.st
3) Perform a table move
proutil sports -C tablemove SlowTbl "TMP Area"
4) Perform the binary dump on SlowTbl