There are limitations in network performance, irrespective of the hardware used. For example, I have a 50 user network, some PC's are Celeron 400's, whilst mine is an Athlon 750. Running reports and SQL's take almost exactly the same amount of time on both PC's. All PC's have 100BaseT NIC's, and the server is a Dual Xeon. This is caused by a bottleneck at the server end. The server feeds the data so slowly back to the calling PC's that the faster PC's, i.e. my Athlon 750, is sitting around doing relatively nothing, whilst the Celeron is going at full speed. To all intense purposes they look as though they are operating at the same speed !!!!!

Are any of the other PC's trying to retrieve data at the same time as your application ? Unless you're using RAID on your server, the hard drive in the server can only read OR write at any one moment. If someone else is retrieving data from the server at the same time as another PC, then things will be slow.

The more concurrent PC's using any shared VFP tables, the slower it becomes for everybody.

Exhaust the programming possibilities before you invest in any new hardware. You'll only look foolish if you spend money on a new server with RAID, and then find that things are no quicker.........

Derek