Why does this statement take so much longer on a faster machine?

Torquinian 1

I am using VS2022 and Basic. I am finding that when the compiled EXE is run on an old APP Server with old Visual C++ Redistributables that this statement runs acceptably fast, but if I run the same EXE on a new APP Server with current Visual C++ Redistributables, this statement runs much more slowly and I wonder if anyone has any ideas.

            While reader.Read

                cboOrderNo.Items.Add(reader("orderno"))

                cboHiddenPId.Items.Add(reader("p_id"))

            End While

The statement in question is the one where the OrderNo Combo box is being populated. If it is commented out, the module runs as quickly as expected, but with the PId Combo box being commented out it is much slower. The reader("orderno") field is from an SQL Database, varchar(6) and each entry is 6 characters long.

The old APP Server has 16GB, the new APP Server has 128GB.

Viorel 120.4K Reputation points

2025-02-28T17:46:16.3866667+00:00

(Removed)
Torquinian 1 Reputation point

2025-03-01T17:30:37.64+00:00

For clarification, both APP Servers were accessing the same data on the same SQL Server, but not at the same time. There are less than 28000 records involved.
MotoX80 35,596 Reputation points

2025-03-02T14:16:35.4166667+00:00

I wonder if anyone has any ideas.

Are both APP servers on the same network subnet? Use tracert to check network performance.

Use Process Monitor to see what file/registry/network calls your app makes. Compare the results from the old and the new servers. See if you can identify which calls are taking longer.

https://learn.microsoft.com/en-us/sysinternals/downloads/procmon

Use the Filter menu to isolate the trace to just your app. Then use the Tools menu to view the file/registry/network summaries and see if the app is making the same number of calls to the same resources.

If you are using VS2022 and Visual Basic, then the installed .Net framework or SQL client might play more of a role that the C++ version.

Share via

Why does this statement take so much longer on a faster machine?

Your answer