We have a VFP9 database running on networks. In some case, even with only 2 or 3 users and less than 50,0000 records in largest file, this becomes painfully slow. When one logs into the same databse in single user mode, the same system runs like the clappers (same time of day on network - thus it's not the network per se. The offending network has PCs running on Windows 7 Enterprise with Service Pack 1. The network runs on Extreme Networks switches (1 Gbit). Storage is hosted on NetApp.

When in multiuser mode, the VFP app runs the code:
SET EXCLUSIVE OFF
SET REFRESH TO 1
SET REPROCESS TO AUTOMATIC

There are no special commands in the config.fpw file. I have tried adding ...

TMPFILES=c:\work
EDITWORK=c:\work
SORTWORK=c:\work
PROGWORK=c:\work

but I can't see any files appearing in c:\work so unsure that is working in any case or if it would help?

Appreciate this is rarther general - but any other ideas to help speed things up?
Many thanks.