AnsweredAssumed Answered

Performance trade-offs : 128 bits sparse versus dense and 64bits sparse ?

Question asked by ecausse on Mar 2, 2018
Latest reply on Mar 8, 2018 by ecausse

Hi all,

everything is in the title: very often when designing cubes or cube versioning, I have a choice between these two kinds of structure:

- Entity A (D), Entity B (S), Entity C (S), Entity D (S), Entity E (S) => Smaller physical cube size but 128bits sparsity file.

- Entity A (D), Entity B (D), Entity C (S), Entity D (S), Entity E (S) => Bigger physical cube size but 64bits sparsity file.

 

What are the theoretical pros and cons of such structures ?

 

Thanks,

Etienne

Outcomes