Why would a slower system run a very complex macro but the superior machine won't?
I've been running some reports from Excel (client side) and started using logmein to my home desktop to process some reports that my desktop at work can't handle for some reason. Even though the desktop at home has 8 gb of ram and a duo core processor my work machine has a i5 with 16 gigs of ram. Is there a reason why the slower machine can run this massive macro while the superior work machine chokes out from system resources? I've checked and both machines are running 32 bit version of Office 2010. For the life of me I don't understand why the slower system runs the macro (which takes over an hour) and the superior machine chokes out after 15 - 20 minutes. Any thoughts? On a side note I have closed out Outlook and other applications that could take up resources and no dice. However the home built machine just chugs a long like a little beast. I do have superior parts like system board (ASUS) and a dedicated graphics card 1gb GE force. Along with "Gamer" ram (8 gbs). Is it a matter of quality is better than quantity?
edit: Oh, brand of components and having a dedicated GPU don't matter. Parts only matter if something is actually defective. Slapping a 'gamer' label on something just means they are probably charging more for it. At one point, Nvidia had 'gaming shorts' on their webstore. Not kidding.
Possibly. It may be a calculation issue as well. There are tools you can use to measure the calculation times and settings you can modify for using near real-time system access.
If the macro does anything that touches storage and the storage is a hard disk, certainly look at fragmentation. Always worth running chkdsk to see that there aren't drive problems, regardless. They can manifest in almost any way imaginable, including seemingly random performance problems.
Obviously look at resource utilization outside of that, particularly the performance tab of Task Manager. You can usually get quite a bit just from a glance. For example, if your work machine as 30 more processes and twice as many handles or twice the memory utilization of your home machine, it could easily explain the performance difference.
Complete: 55/120 credits SPAN 201, LIT 100, ETHS 200, AP Lang, MATH 120, WRIT 231, ICS 140, MATH 215, ECON 202, ECON 201, ICS 141, MATH 210, LING 111, ICS 240
In progress: CLEP US GOV,
Next up: MATH 211, ECON 352, ICS 340
Is the drive it is running from encrypted?
In additional to the antivirus software, are there any other security software running on the computer?
2020 Goals: 0 of 2 courses complete, 0 of 2 exams complete