Text Fields

Compared to other data types, text fields take up more processing time and memory.  When working with text fields, consider the following:

1. Disabling the Descriptive property: doing this will force the ElastiCube build process to create and index table, replacing the text values with integers that are the best in terms of performance and size.
2. Limit the size of the field: when a field contain text values with a limited maximum size, be sure to set this value as the field's size property.

 

Floating-Point Fields

Floating point fields do not perform as well as Int fields.  If a field is of one of the floating point types (decimal, float, real) but all values are actually integers (1.00, 2.00, etc), change the field's data type to Int or BigInt to achieve best performance.

Import Only Required Fields

When you do need a particular field or fields, do not import it and save both build time and storage size.  When a field's Visible property is set to false, it is not imported.