Section: 7. ADMINISTRATOR TASKS
Subsection: 7.2 Database Storage Requirements
Topic: Database file size estimates


File size estimates for the Scorecard Notes database are detailed in the following table. Notes Administrators should plan for 16 meg of server storage per quarter and 62 meg per year.

Data
Size (bytes)
Scorecard Data
65,513
History Bitmap
157,691
Graph Bitmaps (19)
@ 41,316
785,004
XLS Attachment (compressed 37%)
from 347,648
128,630
Attachment Overhead
3,664
Data Subtotal
1,140,502
Excel File
SCARDB1.XLS
280,576
SCARDB2.XLS
347,648
Forms
Attachment
1,641
Graphs (19)
@ 1,511
28,709
History
1,200
Icons
41,239
Scorecard
312,718
Forms Subtotal
385,507
Views
Score Views (5)
@ 10,764
53,818
Attachment Views (2)
@ 4,931
9,861
Admin Views (3)
@ 10,268
30,803
Views Subtotal
94,482
Other
Help Doc's
4,459
DB Icon
0
Unaccounted (plus test forms)
750,730
Other Subtotal
755,189
Total Database
2,375,680
Annual DB Size Estimate
Fixed DB Overhead
1,235,178
Variable DB Size (1 Region-Month)
1,140,502
Total (Minimum Size)
2,375,680
Per Month (4 Regions)
5,797,185
Per Quarter (4 Regions, 3 Months)
14,921,199
Per Year (4 Regions, 12 Months)
55,979,262