Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
NT Server and Win95/98 Network Performance
Message
 
To
24/05/1999 19:09:31
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00222264
Message ID:
00222399
Views:
25
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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform