A user is experiencing slow application performance when another user logs into the application. Its a VFP9 exe running on Win7 machines. The EXE is on each workstation, while the database (DBC... with local views) sits on the server PC. Three of the more data-intensive screens contain several different tables and several different local views. When a single workstation user is running the App, these screens will load/display in approx 4 seconds. 2 seconds on subsequent loads. When another user logs in to use the app, these same dbf/view-intensive screens can take much longer to load. However, running some of the lookup table options -- which consists of a form pertaining to just one dbf (with one or two views), that form loads very quickly... regardless of the number of application users. I have added some file type exclusions into their copy of Windows Defender with no joy.

I suspect that the DBC is being locked while the view definitions are being read when those particular data-intensive options are being run. Does that sound plausible? Any recommendations? I recall reading articles recommending that the view defs be deployed on the workstations to avoid contention, but i'm not familiar with how the forms would use the local view definitions or how that impacts the use of views within the form's data environment.

Thanks.

On a side note, i believe this is more of a problem on Win7 PCs than it was on XP boxes.