Previous Topic: Method OneNext Topic: Method Three


Method Two

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