>>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


I've discovered that when TCP/IP is the primary protocol that this problem occurs. IF IPX is used, the problem goes away. Anyone seen this before?

John Brooks