Only the fact tables will be considered for Primavera Data Warehouse database sizing purposes because they are responsible for most of the data. Spread and resource limit data are initially loaded into holding tables (_FS suffix), so sizes are doubled for these tables.
Data Component | Calculation | Rows | Size Example |
---|---|---|---|
W_ACTIVITYSPREAD_F | 300 bytes/row | 5,000,000 x 2 | 3.0 GB |
W_RESOURCE_ASSIGNMENT_SPREAD_F | 175 bytes/row | 5,000,000 x 2 | 1.6 GB |
W_RESOURCE_LIMIT_F | 70 bytes/row | 1,825,000 x 2 | 0.125 GB |
Dimensional and Temporary | 20% of Spread | n/a | 0.9 GB |
W_Project_History_F | 265 bytes/row | 6000 | 0.04 GB |
Total |
|
| 5.6 GB |
Note: The above sizing does not include the W_Activity_History_F and W_WBS_History_F tables, which will be the largest if the History Interval is set at Weekly and the History Level is set at Activity.