To the PowerPivot Elites:
How dependent is PowerPivot based on RAM/hardware? Would there be a large performance gain in PowerPivot if I increased the available ram from 4gigs to the maximum my laptop can hold to 8gigs?
I'm on a Dell E4310 Core I5 with 4 gigs of ram. However, I noticed when I analyze over 2 million rows with multiple linked tables, the query time slowly increases and my Excel crashes every once in a while. What do you think?
How dependent is PowerPivot based on RAM/hardware? Would there be a large performance gain in PowerPivot if I increased the available ram from 4gigs to the maximum my laptop can hold to 8gigs?
I'm on a Dell E4310 Core I5 with 4 gigs of ram. However, I noticed when I analyze over 2 million rows with multiple linked tables, the query time slowly increases and my Excel crashes every once in a while. What do you think?