Posted on 2004-11-16
There is a VB procedure. It makes thousands of calculation.
This procedure is running on a Windows XP system with dual processors in HyperThread mode to emulate 4 processors. It takes 20 minutes to complete the calculation.
I am not experienced on hyperthreading (actually even multithreading). This is a curiosity question (also as I am almost sure that it couldn't be possible to use different CPUs for the same process in same application's same session but it wouldn't hurt if I am wrong!).
This is the all information I have.
Question: Is it possible to split the "same procedure" to make it processed by "4" CPUs at the same time and reduce the processing time less than 20 minutes (consider 20 minutes is the best time)?
BTW: It is actually a VBA module that works in Excel 2003 application but I am willing to update it by using a COM-Addin that is created by VB if such a thing is possible.
PS: I will be able to read replies tomorrow, so I might not reply soon.