Frequently asked question

Why are update operations slow using the ESRI OLE DB provider ?

Last Published: April 25, 2020

Answer

Performing multiple update operations on an ESRI data source using the ESRI provider can be slow if the update operation is undertaken without using an ADO/OLE DB transaction. For best results, always use an edit transaction when updating. These transaction are opened, rolled back or committed on the ADO connection object.

Applying updates to a versioned ArcSDE geodatabase may also be slower due to the overhead of versioning.

Article ID:000002713

Software:
  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic