In our office we use two main programs. One is only installed on one machine but can be and is run on the other (client) machine.

The other program is installed on both machines but the data base is shared between machines.

The problem is we changed the configuration of the network, we used to have a Linksys router and 2 hubs to connect all the machines in the building. At that point there was a few seconds lag in opening a work order.

One hub failed so we got a dlink 16 port switch, now the lag is up to 45-50 seconds which is unacceptable.

We've tried a different router and have tested the cables and replaced one that had a pair of wires crossed. That improved file transfer speeds but the lag in these programs remains.

Does anyone have any ideas what might improve this situation?

TIA