I'm setting up FoxPro file sharing, but have noticed some performance issues I'm hoping someone can shed some insight on. We have a peer to peer network using Windows 95 file sharing. I have one PC as a dedicated server that has all database files and our application. It has the processing power of a Pentium-75, 16 MB RAM, and a 500 MB hard disk. The local (client PC's) each have FoxPro 2.6 for Windows and a Config.fpw file that points to the mapped network drive, sets tmpfiles to the local drive and sets the resource file to the local drive as recommended in the Developers Guide. The local PC's are 133MHz Pentiums.
Everything seems to work, but the performance is not good in all cases. An RQBE query that takes 15 seconds run locally, takes 2 minutes across the network. A large calculation program takes 15 minutes locally and 25 minutes across the network.
Is there something else I can do to speed things up or is this what we can expect from this type of network setup? Just to let you know, I'm not network savy and this is the first PC network application I have ever set up.
Martha Harris
University of Vermont