Here’s what a recent PowerPivot process looked like
- 14,512,074 Rows
- 7 Columns
- 14:09 to load data from SQL Server at 30M
- 5:36 to save file
- 129MB file size
- 0:14 recalc time
- 1,559,700KB used by the EXCEL.EXE process
On this client machine:
- Windows 8.1 Pro 64bit
- Excel 2010 64bit
- 36GB RAM
- 2.4Ghz Xeon processor
Leave your story in the comments.