0
0
Possible Duplicate:
How do you keep Microsoft Excel running at full speed even when it does not have the window focus?
Running Windows 7 with Office 2010.
We are seeing a huge slowdown (4x to 10x) running certain Excel macros when Excel loses focus. For instance a macro that usually runs in 35 seconds slows to 160 seconds if notepad is given focus. I understand that the process that is in focus will get 3x thread time quantums but if it doesn't need any processing I wouldn't think it would block the Excel process so badly.
Is there any way to change the quantum on a process or thread basis in Windows 7?
I used a free tool "Yet another process monitor" to zone down on the Excel.exe process and all its related threads. Boosting its priority as well as all its threads' priority doesn't seem to have any effect.
Is there a way to control the time-quantum for those threads instead?
Also, changing the registry does not seem to make any difference either:
[HKEY_LOCAL_MACHINE \System \CurrentControlSet \Control \PriorityControl]
Win32PrioritySeparation = 0
- Optimize Performance for Applications: 32 + 4 + 2 = 38 and gives Short Quantum, Variable Quantum for foreground, High foreground boost.
- Optimize Performance for Background Services: 16 + 8 + 0 = 24 and gives Long Quantum, Fixed Quantum, No foreground boots.
Any ideas?
Are you accessing these files over a network? Any of these problems on Outlook 2007 also? – KCotreau – 2011-07-20T17:34:18.940
Someone else asked this question over here: http://superuser.com/questions/6400/how-do-you-keep-microsoft-excel-running-at-full-speed-even-when-it-does-not-have There are a couple of upvoted answers over there, possibly helpful for you.
– joweiser – 2011-12-11T22:58:05.867