Will it be real time, not a chance, could it be 1-2 mins, quite possibly. but you are probably hitting diminishing returns at that point. Or go workstation class machines, high end desktop, threadripper, xeon etc. Intel you are stuck on 8 cores unless you go i9, in which case 8 core 16 threads, and something that is a monster to cool, is high in the stack and I wouldn't want it in an office machine (v noisy without careful consideration). Personally I'd be thinking next gen ryzen (coming very soon), get an R7, and you might get 12cores, 24 threads (if rumours are true) at a decent clock speed (rumours). The key question is how parallel is the data, if each 'row' is independent of others then you can create a high degree of parallelism, if each core is not then you will struggle.ĭoes anyone in the business have a better PC? Can you encourage any suppliers to 'demonstrate' a PC with a modern CPU? Thank you very much in advance for your honest advice.ġ00% on both cores? including HT cores? how much memory are you using? In general everyone we speak to underestimates our level of need because they do not understand our work. Our IT firm is horrendous and has been really unhelpful here. Some are going to tell me I should use Tableau or something else for these files and I would ask those people to, respectfully, please press the back button on your browser now.įor Excel in particular, are there any limits to how much it can take advantage of clock speed, cores, or i7/I9/Xeon?ĭoes anyone have ideas on the best path to take to not have CPU be a bottleneck? What computer should we be buying? We’d probably pay up to $4k per machine if necessary. Because of the nature of our work, we are willing to pay for something that will be lag free for everything we do because it will directly pay for itself many times over. There would be a major financial return on investing in high powered desktops or laptops for our organization and I have convinced the firm of the need. I’m running a dual core i7 with 2.7ghz or so and 16 gb of ram - so lots of room for improvement to say the least.Įven when not working with these very large and complex files, my CPU reaches 100% utilization literally every single day and causes significant efficiency to my workflows. As a result, my company-issued laptop which we use as a desktop replacement, a Lenovo ThinkPad X1 Carbon, either can’t do these tasks or it can take several days to do a task that could have taken 20 minutes if it weren’t for the lag. At the extreme, this can be as much as 20 million data points, with millions of rows of volatile formulas such as indirect functions, index match, etc running off of this data, interconnected across dozens of tabs. I work at an investing firm and we often receive significant amounts of data on companies that we need to crunch in excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |