| Database Compression Effects on SSAS Processing |
| Written by Boyan Penev |
| Thursday, 23 June 2011 18:59 |
|
Just recently I was optimising the processing time for a rather large cube on my laptop. The hardware I used was not tremendously powerful (a mobile i5 CPU, 8Gb RAM and one 7200 RPM hard disk) and having a 500M rows fact table proved to be somewhat of a challenge for it. The set up was fairly typical - a large fact table, with a few dimensions in a typical start schema. The goal was to get it to process as fast as possible. Read more... |
