Forum Discussion
Terrible recalculation speed on Ryzen processor
Hi, my name is Bill Wu, I'm a member of the Excel team. Thank you JKPieterse for alerting us to the issue.
ctz69 I'm sorry you're experiencing this problem, and I hope you could provide some information to help us better understand this.
1. You wrote this is something that has changed within Excel. Do you happen to remember what the execution times were on both the Ryzen and Intel previously?
1a. Or, was the Intel execution time the baseline and things got worse when you moved to the Ryzen?
2. If you similarly turned off multi-threaded calc on the Intel do you also see the drop in execution time?
2a. If you changed the Calculation setting on the Ryzen to use 4 processors, is the performance similar to the Intel?
3. We are aware of certain spreadsheet models that don't scale well with more processors, but if it this a recent change in behavior it may be something different. Would you be willing to share with us a copy of your workbook for further analysis? The data can / should be obfuscated, or it could be a simplified model as long as we can reproduce the problem. If you are willing, we can take the next part offline to work this out, including privacy / confidentiality concerns.
Thank you,
Bill
- ctz69Oct 18, 2022Copper Contributor
1. You wrote this is something that has changed within Excel. Do you happen to remember what the execution times were on both the Ryzen and Intel previously?
Today, I added the multi-threading back in and calculation times on the Ryzen CPU went back to the 4 seconds or so time that I had before. Not sure what has changed, but the file did not. I guess the re-calculation efficiencies were added back in. The single-thread time is still around 1 second. The Intel CPU is about 1 and 4 seconds for single and multi-threaded, respectively.
1a. Or, was the Intel execution time the baseline and things got worse when you moved to the Ryzen?
The Ryzen was about the same time as the Intel until the 40 seconds I got recently. It's gone back to the previous time for some reason.
2. If you similarly turned off multi-threaded calc on the Intel do you also see the drop in execution time?
Yes. About 1 second similar to the Ryzen.
2a. If you changed the Calculation setting on the Ryzen to use 4 processors, is the performance similar to the Intel?
Now that it's improved greatly, this probably isn't necessary.
3. We are aware of certain spreadsheet models that don't scale well with more processors, but if it this a recent change in behavior it may be something different. Would you be willing to share with us a copy of your workbook for further analysis? The data can / should be obfuscated, or it could be a simplified model as long as we can reproduce the problem. If you are willing, we can take the next part offline to work this out, including privacy / confidentiality concerns.
Probably not necessary now.
Thanks