Hi all,

This is a very general question and any feedback is welcome.

We have an application that uses local views against a VFP database. When we ran our application locally, both exe and data is on the local drive, the performance is good. Opening the application locally three times does not significantly affect the performance of the application.

However, when we have the exe and data on a local area network, the performance drops significantly for every new user opening the application. Given that I was the first user to login to the application, the performance degrades for each new user. But, when all the other users logout of the application, the performance on my instance of the application never recovers back to the original performance. It still drags as if there are still other users logged on.

LAN Setup:
- W2K server
- 1GB lan
- Largest table size: 4MB
- App creates a temp database to hold the local views located next to the exe (network).
- SET ENGINEBEHAVIOR 70

Again, ANY kind of feedback is appreciated, including: suggestions, recommendations, i told you sos, whatever.

Thanks.