4 ms·
How many rows can you have in your spreadsheet before performance starts to become an issue? (I noticed the table isn't lazy-rendered, which sparked the questi
by nivenhuh 8y ago
How many rows can you have in your spreadsheet before performance starts to become an issue? (I noticed the table isn't lazy-rendered, which sparked the question.)
- egeria_planning 8y agoA single view should not get too large. The system will not show more than 60000 cells in one view. You will get an error message. The cube itself can grow very large: 10-100 million filled cells. The trick is to design the dimensions so, that only a small portion of the data is visible at once. You can group large dimensions by a column to build a hierarchy (category/model/sku or region/point of sale). This way only a portion of the data is shown at once.