>>I'm using the OLEDB provider on this one.
>>
>>I have a VFP table, on my HD, and when I issue a DataAdapter.Update(DataSet) for around 2,500 records, it takes about a minute. There are 36 fields on the base-table.
>>
>>Is that normal?
>
>Have you installed VFP7 SP1? It fixes some problems with OLEDB provider:
>- Memory leak adding multiple records in a loop using ADO
>- Poor performance with ADO RecordSet LockType property set to 4 (adLockBatchOptimistic)

Yes, SP1 is installed.

Kev