Kbase P7972: How can the extents of my Database affect performance ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/02/2010 |
|
Status: Verified
GOAL:
How can the extents of my Database affect performance ?
GOAL:
Can performance be affected by database extents ?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
There are two situations in which extents can affect performance.
1) If extents reside in different physical disks there will be more disk arms working to get the data, thus improving performance. If the DB is working on a disk array there is no way to control this, but the data will be scattered in different disks.
2) If the size of the extents is bigger than 1GB it can seek data much faster within the file than if it is smaller. When making a capacity plan, try to keep data in fixed extents and use the variable ones just as overflow to avoid the 2 GB limit on some operating systems.