Performance of DataAdapter.Update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm using VS.NET 2003 to create a data framework for my applications. An application can request data about a customer, edit it and save it back to the database (SQL 2000).
Some applications edit a lot of the data or create new rows (sometimes >100.000 rows). It takes the DataAdapter very long to save the changes. Is there a way to speed things up, maybe batch updates?
 
ADO.NET 2.0 will support batch updates, but for now, it's going to do it row
by row. Assuming the update query's performance is ok outside of ADO.NET,
I'd consider sending the updates back sooner and working with smaller result
sets. This won't really 'speed' things up but if done at regular intervals,
you may be able to reduce the perceived wait time for a huge update.
Daniel said:
Hello,

I'm using VS.NET 2003 to create a data framework for my applications. An
Click to expand...
application can request data about a customer, edit it and save it back to
the database (SQL 2000).
Some applications edit a lot of the data or create new rows (sometimes
100.000 rows). It takes the DataAdapter very long to save the changes. Is
Click to expand...
there a way to speed things up, maybe batch updates?
 
Back
Top