VB Performance Issues on a Mulitprocessor Box

[RyanBerg]

I am developing a VB Application that Utilizes MS Word VBA objects.&nbsp;&nbsp;On a Uniprocessor machine it runs great! However on a Multiprocessor machine it runs unbelievably slow! Does anyone have any suggestions or help? Thank you!<br><br>Ryan Berg<br><A HREF="mailto:ryanb@techservgrp.com">ryanb@techservgrp.com</A>

 

[MikeLacey]

Hi Ryan,<br><br>That's interesting. Could it be that the objects you're using (in Word VBA) are blocking each other - so that you only ever get a single instance of a particular method active at any one time? (I'm guessing here and hoping that I don't look *too* silly)<br><br>You could test this, I think, by creating a small test program that repeatedly calls a single VBA.Word method. You would have to choose a method that takes a while to run. The program would insert a row into an Access table (with one of those autoincrement primary key things that Access does) before and after it calls the method.<br><br>Then you would run two versions of the program, each inserting into the same Access table. This would let you see if both programs can call the method at the same time...<br><br>It might be that if prog A calls a particular method after it's been called by prog B - but before it's finished - prog A will sit and wait..... spinning its wheels so to speak.<br><br>As I said, I'm guessing.<br> <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>Please -- Don't send me email questions without posting them in Tek-Tips as well. Better yet -- Post the question in Tek-Tips and send me a note saying "Have a look at so-and-so in the thingy forum would you?"

 

[Karl Blessing]

From what I know isnt a multiprocessor system only supported by NT if its windows., in any case maybe your program isnt upto mark for an NT box, also what Mike is mentioning, on a multiproccesor system each CPU takes a task, now it may execute a program, but only one CPU is going to take a task, you arnt getting double the speed of one just because 2 are working, just means you can having it doing more than 1 thing at a time. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)