>Along with the suggestions for programming optimization, I would suggest going with fater computers. I know this is sometimes easier said than done, but Pentium 120's are pretty slow computers by nowadaze standards...at least upgrade the RAM (I would first add RAM to the client and then to the server...the more the better). Also, Fast Ethernet (100Mbs) is no longer expensive...if you are not using it, that is one way to speed things up. I'd also suggest going to Windows NT if possible (maybe after upgrading the computers). I was never too impressed with Windows 95's networking.

In my experience, you'll see no noticeable performance increase by going to 100BaseT from 10BaseT unless the delays are due to network congestion. In a previous situation I ran tests pulling data from SQL Server and the only time there was a performance increase (aside from the congested times as mentioned above) was when I was pulling a huge answerset (on the order of 30 Mb) from the server. Other than that, there was no difference either in pulling data from the server or using DBC/DBF on the networks (both NT and Netware 4.1)

Christopher