Why is adding Excel VSTO slower on a taller specialized machine?

Question

I developed the Excel 2003 application in C # using VSTO and VS 2008. Adding works fine on my machine (HP NC6320 laptop, 3gb RAM T5600 1.8ghz Core2 cpu), however, when it is tested for other users (HP nc6710b, 2gb RAM, T7200 2ghz Core2 cpu), it is much slower. I also tried this on another laptop of the same type as mine, and it is also fast

I went through obvious things like running applications, antivirus materials, etc. Cars are fully fixed and updated.

In principle, what addin does: 1. Read data from a SQL Server 2005 database 2. Do some manipulation on it 3. Display it on a sheet and format it accordingly

A slow bit is a display on a sheet.

I am stumped about why this would be slower on a newer machine. To really embarrass myself, I tried this on a VM (VMware Workstation v6.5) with 256 MB of RAM and 1 processor running on xp and only Office 2003 was installed on it, and it was much faster than a new laptop.

So, Excel Addin runs fast on a low specification VM, and on an older laptop, but on a newer laptop, it is slower.

Any suggestions would be greatly appreciated?

Thank you very much

Nick

change

Ok, I checked the printer drivers, they are the same ... I checked the levels of fragmentation, and if anything, a faster machine is less fragmented than a slower one.

Let's look at the event settings.

Answer 1

You can also add

Application.EnableEvents = False 

Before you start dumping data into a spreadsheet, to stop any other Excel add-ins or any VBA code that is waiting for the update / update level to change. Remember to reactivate events upon completion!

Answer 2

Make sure that any XLA or COM add-ons (for example, Google Office Addin) or any other potentially dangerous code to track events in Personal.XLS, etc. are not installed on the slow computer.

Presumably, you are already doing all the standard accelerations, such as: - disabling automatic calculation and turning off the screen before recording to XL - recording and formatting cells in one large block, and not in a cell -...

Answer 3

Update your office to the latest version (see the Microsoft website / Microsoft Update).

Check the version of the installed VSTO / PIA ...

Check the installed office / excel plugin.

Use the profiler to find out which call is slow.

Answer 4

One thing that I notice between a faster computer and a slower computer is 1 GB of RAM. Have you checked the memory usage on the machines while the application was running? I know that 1 GB of RAM has made some serious progress (at least in my perception) of the speed of computers to do something.

Answer 5

I came across newer higher performance laptops that have terrible hard drive performance. You may also have fragmentation.

Answer 6

Check the printer driver that you configured on both machines. In fact, to eliminate this, switch to one of the file-based drivers (for example, Microsoft XPS). I am having problems with the fact that Word takes a lot of time to make material based on the printer driver, and Word needs to check what the printer is capable of in some situations.

Answer 7

If Vista is installed on computers, you can enter System Information (the fastest way to get a Windows key + Pause, I don’t know how to get a slow way through the Control Panel). It will show a set of five performance numbers: memory performance, hard drive performance, graphics performance, etc. Compare these numbers on two machines; it may be that a "newer" machine has slower RAM or a slower hard drive.

Answer 8

Check how many files are in% temp% on each machine.

Answer 9

Are some of the machines running a 32-bit OS and others are running a 64-bit OS? Mixing 32 and 64 bit code will add overhead?