Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select * from ...
Message
De
09/09/1998 15:20:09
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00134650
Message ID:
00134747
Vues:
12
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform