Forum Replies Created
-
Posts
-
I replaced my HDD with SSD two years ago and can’t cite the specifics but I do recall my boot time was cut from 2 minutes to 30 seconds, Excel Program load was cut in half, large data model loads were improved but sheer file size and i/o limits of SSD obviously come into play here. BTW my SSD was not leading edge at the time and certainly slow by today’s standards.
Calculation time was not improved by SSD.
I too have 16GB memory, but notice in Task Manager I seldom use more than a few GB. Suggest you monitor your memory usage before investing in 32GB.
Another dynamic in play here… as Power Query has evolved over the past few years… I do more & more ETL type processing in PQ before data ever gets to PowerPivot. The SSD certainly helps PQ with data loads from local files… and now my data models are somewhat simpler and more efficient.
Hope that helps.
