Strategy ONE
Sizing
Ensure that the Intelligence Server has the capacity to support all PRIME cubes in memory. Additionally, ensure that the server meets all the system requirements, and has enough capacity for both hard drive space and RAM.
As a general estimation of memory consumption, RAM can consume up to three times as much as the MSI Table size.
Use the following table as a reference.
|
Warehouse |
MSI Table |
|
|---|---|---|
| datatype | datatype | Bytes per row |
|
FLOAT |
FLOAT |
4 |
|
INTEGER |
INTEGER |
4 |
|
SMALLINT |
SHORT |
2 |
|
DECIMAL (10,0) |
DOUBLE |
8 |
|
DECIMAL (21,3) |
Big Decimal |
21 |
|
DATE 'YYYY/MM/DD' |
DATE(short-short-short) |
6 |
|
CHAR / VARCHAR / NCHAR / NVARCHAR (m) |
UTF8_STRING(m) |
X*(m+1) If it is Linux, X = 1 or more |
|
CHAR / VARCHAR / NCHAR / NVARCHAR (m) |
STRING(m) |
Y*(m+1) If it is Windows/AIX, Y = 2 or more |
In the case where the cube has multiple tables, the MSIFile Table size of each cube can be combined to estimate the peak memory requirement.
In-memory partitioning generally results in more memory requirement as compared to no partitioning.
For a better understanding of the PRIME cube structure, enable Engine -> CSI logs before publishing cubes.
