Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: Scott Malinowski
  Where is Scott Malinowski?
 Vermont - United States
 Scott Malinowski
Subject: RE: VFP6 Slow with multiuser in Windows Server 2003
Thread ID: 78510 Message ID: 78520 # Views: 2 # Ratings: 1
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Tuesday, October 04, 2005 8:46:12 PM         

Hi Scott

> I have an accounting package that runs on VFP6. We have had some users upgrade servers to Windows Server 2003. They report that when one user is in, things are fine, but when multiple users are in there is a terrible slow down.
> Anyone experienced this?
> Normal solutions for us are to look at network infrastructure, server caching (and turn it off!)

The most usual cause of this one, apart from the write-behind caching which you have already caught, is grids that use filters on tables. I have seen this one in several places, so I am slightly surprised that it has not been noticeable before - it certainly happened under Win2K. (Oh, sudden thought! Maybe they were still on NT prior to going to Win 2003 - I am not sure if it happened under NT or not)

Anyway about the only 'fix' I know of, if it is this one, is to replace the filtered tables with parameterized views in the grids - then all is well. Alternatively if you can upgrade to VFP 9.0 you will find that grids can now make use of Rushmore Optimization to get around this issue.

Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA


VFP6 Slow with multiuser in Windows Server 2003 Posted by Scott Malinowski @ 10/4/2005 6:03:13 PM
RE: VFP6 Slow with multiuser in Windows Server 2003 Posted by Andy Kramek @ 10/4/2005 8:46:12 PM