Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow on network nodes
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00351356
Message ID:
00351399
Views:
24
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
Previous
Reply
Map
View

Click here to load this message in the networking platform