>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only