I’d had Excel open for awhile and probably hadn’t closed Excel.exe completely after closing the native Excel file. Not quite sure what was going on with that 600 MB number. Still 2x better than Excel, but 8x is much better 🙂
Good thing I ran the experiment twice!įirst time I did this, the PowerPivot RAM number was 600 MB. 8x better in RAM, 12x better on disk! (I was SO tempted to use a pie chart. Hypothesisīased on my knowledge of PowerPivot compression, I expected that PowerPivot would do a little bit better than Excel on disk, and a lot better in RAM.ĭidn’t quite turn out that way 🙂 Results So I decided to do a “before and after” comparison. And so on.īut this was the same machine I had used to do a PowerPivot demo with a 100M row data set, which ran with no problem! 0.5% of the data was bogging me down in Excel! And my machine labored to do anything at all with that data – opening it took forever. The data was provided as a (regular, non-PowerPivot) Excel file with 500K rows in it. Sorry Sam.īut today I was playing with a data set on my desktop machine that was really getting me down. I then, of course, forgot all about it until today.
“Best not analyze too deeply on this one, huh?”Ī long time ago I promised a guy named Sam that I would dig up some examples of PowerPivot compression.
0 kommentar(er)
