Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance when inserting 1000's of records
Message
 
À
27/02/2003 11:40:14
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Divers
Thread ID:
00758838
Message ID:
00759296
Vues:
16
>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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform