PowerPivot: improve the performances by sorting tables

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

While it is well know that in UDM data should be loaded sorted, to get better file compression and map structures. The world of PowerPivot (and BISM) is yet not explored. Working with a 50 millions rows table, I tested various scenarios to check if sorting affects BISM data structures too.

The fact table structure is very simple:


Tags: performance, tip, load, excel


2007-2015 VidasSoft Systems Inc.