jeremypyle
Board Regular
- Joined
- May 30, 2011
- Messages
- 174
Hi,
I have a i5 4690K CPU which currently goes to 100% usage everytime I do big excel formulas. I have to wait for a few minutes for it to finish.
Is there a better CPU that I could get that would make it many times faster? For instance a high end extreme cpu with more cores (say 8 plus), though it seems the mores cores they have the more the clock speed generally drops on them. Would I benefit from having more cores and threads, or having a higher clock speed?
At the moment I have my chip maxed out at 4500ghz. Its a four core/four thread chip. I'm prepared to spend quite a bit in upgrading it, but would it make much difference?
I read in a blog online that someone ended up buying a really expensive CPU with more cores and then excel ended up getting slower instead of faster, because the clock speed per core was lower on the new one:
https://fastexcel.wordpress.com/201...tion-speed-by-changing-the-number-of-threads/
His suspicion was that excel doesn't use all the cores/threads anyway, and that having a higher clock speed was more beneficial. Would love any thoughts and advice!
I have a i5 4690K CPU which currently goes to 100% usage everytime I do big excel formulas. I have to wait for a few minutes for it to finish.
Is there a better CPU that I could get that would make it many times faster? For instance a high end extreme cpu with more cores (say 8 plus), though it seems the mores cores they have the more the clock speed generally drops on them. Would I benefit from having more cores and threads, or having a higher clock speed?
At the moment I have my chip maxed out at 4500ghz. Its a four core/four thread chip. I'm prepared to spend quite a bit in upgrading it, but would it make much difference?
I read in a blog online that someone ended up buying a really expensive CPU with more cores and then excel ended up getting slower instead of faster, because the clock speed per core was lower on the new one:
https://fastexcel.wordpress.com/201...tion-speed-by-changing-the-number-of-threads/
His suspicion was that excel doesn't use all the cores/threads anyway, and that having a higher clock speed was more beneficial. Would love any thoughts and advice!