>Hi,
>
>I've run across an interesting situation with a multi-user VFP 5.0 app running on a NT 4.0 Server. When one user is in the system, the screens search and redisplay data in 2 sec, but when a second user goes into the system enough that the same tables are opened, performance for the same search routine drops by 300 %.
>
>The same test run under Novell stays at the same 2 sec search speed no matter how many users are in the app.
>
>Any ideas on what I can set in the app that would cause this? Or on the NT Server itself?
>
In all probability, you need to make some changes to the NT Server configuration to support a larger number of open files. I'd also strongly advise applying SP5 to NT Server; among other things, SP5 addresses the issue of NT Server sometimes holding a file open after the workstation has dropped its connection.
>Thanks,
>
>John Brooks