Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Slow on network nodes
Message
De
28/03/2000 10:41:25
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00351356
Message ID:
00351399
Vues:
25
Brad,

>I have three pc's connected through Windows 98, sharing one of the drives. I use an SQL SELECT
>to build a temporary file of a customers bills. Then the operator selects one to review. The Master File has
>50,000 records in it. This process is very fast if the operator is working on the server (about a second).
>If the operator is on one of the other pc's the same process takes about 10 seconds. What can I do to
>speed this up?

Which process takes about 10 seconds? The SQL SELECT, the operator selecting one to review, or retrieving the selected item?

If the SQL SELECT, please post the SELECT statement for us to see, and tell us what your index tags are for that table.
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform