OleDbDataAdapter.Update() slowness
-
Hello, first time asking a question here, so please be gentle I'm filling a dataset and using OleDbDataAdapter.Update() to insert it into a DBF table using Jet. The update is running painfully slow and I've read up a bit on how to speed up and saw something about starting the transaction before running the update. Doesn't really seem to do much for me. I have a table write that goes on for 24 minutes. Any help would be appreciated. Code snippit: If Not cnDBConn.State = ConnectionState.Open Then cnDBConn.Open() End If Dim transID As System.Data.OleDb.OleDbTransaction = cnDBConn.BeginTransaction() cmInsert.Transaction = transID daAdapter.InsertCommand = cmInsert daAdapter.DeleteCommand = Nothing daAdapter.UpdateCommand = Nothing daAdapter.ContinueUpdateOnError = False daAdapter.Update(dsOut, sCurrentTable)