John,
I would check your NT administrater and possible how your handling data across the LAN/WAN. I was running a 35 (10 people on local segment) person multi-user system across a T1 WAN with very little performance degradation. There was a large volume of transactions going across the T1 due to it being a real-time perpetual inventoring system.
Thing that I did that helped:
1) Create a normalized database.
2)Placed executable and supporting file on an NT server on the other side of the T1.
3) Loaded small (50 records or less),static, look-up information that is used through-out the application at start-up time.
4) Used local view with table-buffering making sure to only read and write data when absolutely needed.
5) utilized transaction processing.
6) Used SYS(3051) to optimize SQL statements used in local views.
7) Created supporting indexes on table to help optimize SQL statements.
Hope this helps
Dave.
>Hi,
>
>I've posted this before but I'm really curious if anyone with mutli-user apps running on an NT 4.0 server and using Win95/98 workstations has seen large performance slow downs when multiple users are in the application.
>
>If you run TCP/IP protocol and more than one user is in the app performance drops by 300%. It looks like the problem is in the TCP/IP protocol.
>
>I really could use some help on this.
>
>Thanks,
>
>John Brooks
I would give my left arm to be ambidextrous!