Use the relative sizes of major tables. The relationship is based on analysis of several large production Host Encyclopedias.
|
Table |
Index 1 |
Index 2 |
Index 3 |
|---|---|---|---|
|
DOBJ |
30% |
40% |
40% |
|
DASC |
50% |
50% |
Not applicable |
|
DPRP |
16% |
Not applicable |
Not applicable |
|
DSUBEX |
40% |
40% |
Not applicable |
|
DTXT |
15% |
Not applicable |
Not applicable |
|
DHLOG |
10% |
Not applicable |
Not applicable |
|
DHOBJ |
10% |
Not applicable |
Not applicable |
|
MODEL |
40% |
40% |
Not applicable |
|
PIDATA |
40% |
40% |
50% |
|
PINAME |
25% |
20% |
Not applicable |
|
PITEXT |
25% |
20% |
Not applicable |
Using the information in this table, estimate the number of objects and divide by 70 to get the size of the DOBJ table (in 4 KB pages).
Calculate the sizes of the DASC, DPRP, and DSUBEX tables: DASC = 1.7 X (DOBJ value) DPRP = 1.7 X (DOBJ value) DSUBEX = 1.0 X (DOBJ value)
The factor for DSUBEX is a minimum. If subsetting is not used, or is low, 1.0 is adequate; otherwise, this value needs to be larger.
Example
50 Models x 30,000 Objects/Model = approximately 1,500,000 Objects 1,500,000 divided by 70 = approximately 22,000 4K DOBJ pages DASC = 1.7 * 22,000 = approximately 36,000 DPRP = 1.7 * 22,000 = approximately 36,000 SUBEX = 1.5 * 22,000 = approximately 33,000 DOBJ = 22,000 (see above)
|
|
Table |
Index 1 |
Index 2 |
Index 3 |
|---|---|---|---|---|
|
DOBJ |
22,000 |
7,000 |
9,000 |
9,000 |
|
DASC |
36,000 |
18,000 |
18,000 |
N/A |
|
DPRP |
36,000 |
6,000 |
N/A |
N/A |
|
DSUBEX |
22,000 |
13,000 |
13,000 |
N/A |
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|