Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Time Response
Message
From
14/05/2002 01:06:58
 
 
To
13/05/2002 18:45:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00655894
Message ID:
00655981
Views:
27
>Hello,
>
>Universal Thread has been really helpful however as of now I'm really at wits end... :-\
>
>The users are complaining that the time response is very slow. We have a new Windows 2000 server - Dell PowerEdge 4400, "x86 Family 6 Model 8 Stepping 6 GenuineIntel ~993 Mhz", 1 GB RAM, 17 GB on drive C (utility stuff) and 87 GB on drive D (VFP database/tables). I ran a simple test - a simple view. The table consists of 1,000 records. Using VFP (not a compiled application), opening the view takes less than a second (about 100 records out of 1,000). With another user logged on but without opening the view, it takes 8 seconds. If the other user opens the view, it takes 10 seconds. Now that's just opening a simple view by itself, not running any form, nor any application, whatsoever.
>
>I tried disabling the anti-virus program on the server as well as on the workstations to no success. The anti-virus software on the server (as well as the workstations) is McAfee, not Norton. So it's definitely not the anti-virus software. Anything else I can look into...?

It's hard to comment without knowing a lot more about your environment. But, first of all, AV is the most usual suspect with this sort of problem; are you absolutely sure you properly shut off both server and WS side AV before testing on any workstation? If it's not too difficult you might try completely uninstalling the product for testing, then reinstalling.

Aside from that, assuming fairly modern workstations and 100BASE-T networking you should see sub-second view open times with any ole' piece o' junk as the backend server dishing up that small table.

- Make sure everyone's using a CONFIG.FPW that points temp files to a local disk, not a server disk

Beyond that, you'll need to look at the environment. Is the server CPU busy or is the disk pounded hard? Is there a jabbering network card flooding the network with bad packets? How is network performance of other (non-VFP) apps? Sounds like you're going to need to get your network admin on side for this one.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform