Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Large table takes too long to load
Message
From
10/07/2004 23:26:54
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
 
To
10/07/2004 22:22:45
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00923077
Message ID:
00923084
Views:
20
Hi,
Terminal services or Citrix is your only other alternative.

>I've asked this question before, but I can't find the thread....
>
>We have one of our sites using a VFP application connected to our W2K server through a T1 line; all the VFP tables are kept on that server. Of course, the farther away from the server, the longer the data takes to reach a client application. We have a very large table, patientlist.dbf. If we issue the command
>
>use patientlist.dbf
>
>from the remote site, it takes FOREVER to open on the client. We really only need to get one specific record at a time. When we've triend a SQL-SELECT statement to get the required record, the application opens up the WHOLE table on the remote (taking FOREVER) before it creates the cursor. How can we query the table for the record we need without opening the entire table?
>
>CM
Regards N Mc Donald
Previous
Reply
Map
View

Click here to load this message in the networking platform