Check this Wiki, you could get some suggestions:
http://fox.wikis.com/wc.dll?Wiki~Client/ServerTechniquesPerformance
>I need to search a patient record that sits in a large Access MDB (SQL
server later version) from a Visual FoxPro program. I can setup remote view to accessthe table. But I don't think I can take advantage of index already created in Access. And I don't think creating a temp index on the patient_id
in Visual FoxPro in order to seek the record is a good idea (using Locate is out ofthe question). So, I am thinking about changing the code using ActiveX Data Objects sending Select query to retrieve the recordset,which I suppose the index of the MDB will be used by the OLEDB provider, am I right or wrong? Using remote view on large table is not such a good idea in this case, right?
>Also I need to update the record too. I am using VFP6 accessing Access 2000
MDB.