>>I am trying to setup a form to be used for retrieving data from DOS Foxpro tables through ODBC. The tables have over 200,000 records. I am using parameterized views on each of the tables based on customerID. Querying just one of the tables takes approximately 55 seconds across my NT network to display the results. This will not be acceptable.
>>
>>I have read the VFP Help for reducing the number of records initially Fetched and turning off Memo Fetching and several other optimizing techniques. I made these setting changes on the Query\Advanced Options menu. I assume this the same as using DBSETPROP() or CURSORSETPROP(). Yet I see no difference in retreival time at all. It depends on the size of the table being queried. My customer table only has 7900 records and has acceptable performance, where as all the child tables have over 200,000 records and take a long time(55 seconds) to complete the query even though the final result has a few hundred records.
>>
>>How to I speedup retreival time for Remote Views? Do I create Indexes for the Views and how is that done?
>>
>>Help appreciated.
>>
>>Thank You
>>Elgin Rogers Jr
>
>Elgin, maybe i am missing someting here, but why do you need the ODBC for that? Why not just open those tables and make SQL SELECT?

Nick,

I didn't realize I could open these tables directly without using ODBC. Thanks for that info. I'm still learning. But I just tried creating a Local View (which is the same as SQL Select isn't it? )
SELECT *;
FROM dga;
WHERE Dga.custid = ?lcCustid

and I find that it still takes nearly a minute to retrieve the records I need. Do I want to do some kind of indexing on these tables? Can I do that without changing the format of the tables? They have to stay in their DOS format as there is still a DOS application being used to update and maintain these tables.

Thank You
Elgin Rogers Jr