Friday, October 28, 2011

Add-in Load Times

Recently we found a setting that improves add-in load time drastically, this setting applies to any Office add-in but Smart View will gladly benefit.

In Internet Explorer options uncheck the option “Check for publisher's certificate revocation".  Doing this should noticeably speed up the time for add-in loading.  We have only done informal tests but the results have been positive.  If you want to check out some of the boring details you can read this http://office.microsoft.com/en-us/office-2003-resource-kit/how-office-performs-certificate-revocation-HA001140308.aspx or you can just uncheck it and see if it loads faster…

image

 

My Excel now loads fully in less than 3 seconds (2.66s)!


Update:

Please work with IT departments and understand the security implications prior to making any change like this.  This TechNet article describes why the setting was put in place for Windows Vista and above.  http://technet.microsoft.com/en-us/library/ee619730(WS.10).aspx

2 comments:

GiacomoL said...

The security implications of what you suggest are quite severe. Disabling that option means Internet Explorer will happily accept compromised SSL certificates which have been revoked, for example the ones issued by DigiNotar (the discredited Dutch certificate authority that was compromised by Iranian hackers, and was then used to spy on Iranian citizen when on google, facebook etc). Any other program using IE-based Windows components would also do the same.

Security is always a trade-off between paranoia and convenience, but in this case I'd think long and hard whether a few seconds loading Excel are really worth such a massive risk.

Matt Milella said...

Overall I agree with you and users should always work with their IT department and understand the implications of a change like this. However this is a common recommendation for many software vendors including MSFT and Apple so I think you are right we have to be cautious about the trade off between paranoia and convenience.

http://support.apple.com/kb/ts3297
http://msdn.microsoft.com/en-us/library/bb250503(v=vs.85).aspx

I will update the blog so readers understand this trade off