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