True enough, with one exception: using SEEK and SCAN REST WHILE

I was called in to solve an issue with a web app that sat in another building from the data, with the only connection between the 2 a T-1 that was used by all the folks in both buildings to communicate. Using Access, they had a huge problem. Using VFP with a SELECT I had a lesser, but still very large problem (I tried using their select statements first, as the path of least resistance).

I found indexes on the tables that did the job; demo'd the result (online), and was accused of cheating, using screenshots. So I said "give me a name you know," ran it, and the results popped up.

Oh, the good old days... <s>

Well, actually, the good new days, too: while Lianja SQL Server is SQL 92 compliant, entity triggers and field checks can use KEYMATCH (no record movement), SEEK, etc. So the good old days of real Mike Yearwood (the guru in this department) speed are with us again, where it counts.

Hank

>>Thanks for your reply. Yes, I know that FoxPro for Unx tables are the same as FoxPro for DOS tables. Mi problem is, when I access them remotely, it takes forever to show just 6 rows of data (tables are phisically hundreds of miles away).
>
>This is because VFP pulls entire cdx files in order to look for a record. It is extremely inefficient, and is close to unusable over a slow link.
>
>If you need to pull remote data, consider pulling from a WebService or from a SQL server (if on a LAN/WAN) so the only data that travels is your result set.
>
>>
>>
>>>Foxpro for Unix tables are actually Foxpro DOS tables, so the same principles apply. Make sure that you have the proper indexes so that your SQL statements are rushmore optimizable.
>>>
>>>
>>>
>>>>Hi:
>>>>
>>>>I need your help on this topic. I need to get data from Foxpro free tables that are on linux servers on several states, (yes, they use FoxPro for Unix), so I need to get data from those locations into a web server. The issue on what state to get data from is already solved, our main problem is that getting data from any state is too slow, for example, I use 2 queries to get data from, the frist, gets pacient's personal data, and the second gets the pacient's programmed analysis and the results, if any at the time the query is used. Testing with data on the same web server the fist query takes 1 second, and the second query takes about 3 seconds which is for 6 rows with 20 columns each. Taking the same data to another local server (and accessing that data through Samba), the first query takes almost 30 seconds!!!, and the second query takes more than 3 minutes!!! So I tried accessing the same data thru ODBC but with almost the same results. So I imagine how long those queries would take.
>>>>
>>>>Can you tell me any way to get data without taking too much time?