Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select * from ...
Message
From
09/09/1998 15:20:09
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00134650
Message ID:
00134747
Views:
10
>For one of our developer teams we have a small NT network: one NT server and 6 NT workstations. ( all 4 sp 3). I did the setup myself and, after checking again, I am fairly sure that all the workstations machines (all Pentium pro 200) have the same settings.
>
>The problem is this: from some of the machines doing a select * from anytable, where anytable is a table with 100,000 records, the response time is in the order of tenths of seconds, like between 0.10 and 0.20 and from other machines the query can take as long as 4 minutes. The amount of memory, network cards, software version, both NT and VFP, is the same. in all the machines. As a matter of fact, we bought 7 machines exactly the same, did the setup and gave them to the team.
>
>Any ideas out there?
>
>TIA

Check the CONFIG.FPW and see where the temp files are going to. Also, check the size of the NT swap files and the NT registry files. Make sure there is plently of free disk space for VFP temp files.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform