I remember you asking that question :)

Large table Thread #809158 Message #809158

>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