Office OLE suddenly VERY slow

[GriffMG]

I am off to a client's at the end of the week, to have another delve into why his burnt-in XP SP2 machines still do Word OLE v e r y v e r y s l o w l y...

I've tried all the usual things, antivirus, firewall etc. and have a plan to disconnect an offending machine from their network and make sure that the only authentication going on is local (i.e. quick).

If anyone else has any suggestions, I would be very grateful - the only solution thus far has been to install Windows 2K (a process that takes their engineer about half a day, by the time he's put all the software and whatnot on).


Regards

Griff
Keep [Smile]ing

 

[white605]

If your app will run while disconnected from the network, can we assume that the vfp app runing the automation, the data files, word, the documents or templates, you are using are all located on the local machine. Mabee the printing must go to a network printer. What is the offending code that runs slow?

 

[GriffMG]

Hi,

It is VFP code, and it doesn't get as far as printing. It just takes a file that has been copied from a template, opens it in Word, does a series of 'find and replace' and then something similar with some bookmarks and saves the document - then presents it to the user forany further editting they might want to do.

Each document is typically just a page long (like a fax) and takes (normally) about 3 secs to process, save and present - even on the network.

On some XP SP2 machines this can slow to up to 15 minutes - it's as if the machine is authenticating the user with the domain for each line of code that is executed in Word...

It renders the application useless.

Regards

Griff
Keep [Smile]ing

 

[robsuttonjr]

One possibility I found is virus scan software. Try turning off virus scan on slow computer then testing. Check this link out:

http://www.microsoft.com/technet/prodtechnol/office/officexp/deploy/migratbp.mspx

If you use Microsoft Office 2003 have you applied the latest updates?

http://support.microsoft.com/default.aspx/ph/2530?sid=959

Have you updated all of the pc's to the latest Microsoft patchs

Regards,

Rob

 

[GriffMG]

Hi Rob,

Thanks for the thoughts, but as I said, I have tried removing anti-virus and firewall stuff - makes no difference.

The two articles are interesting, but don't shine any light on the problem either.

I have found that the 'burnt-in' SP2 that Dell ship does not exhibit this behaviour out-of-the-box, and think it is related to COM+ authentication... but I still don't have a solution.

Martin

Regards

Griff
Keep [Smile]ing

 

[GriffMG]

Update:

Went to clients' site this morning, tried everything I could think of - with no success.

Found that SP2 was available for uninstall in the 'Add/Remove Programs' feature and tried to remove it.

This failed with an 'Access Denied' error for some reason, so I followed the M$ web site instructions and tried again in Safe Mode using the command line approach.

Funnily enough this didn't seem to have removed SP2, but the slowness problem went away!

So, I stopped there - did a Windows Update (which also failed, and said I should remove SP2 and retry [which still didn't want to work]).

Thus we are left with a fully functioning PC, running as it did before SP2 was applied, that thinks it has SP2 but which cannot now update... not perfect, but usable.

Regards

Griff
Keep [Smile]ing

 

[markros]

Perhaps this

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1619925&SiteID=1

is somehow related.