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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataAdapter.Update is not working 8
If we move the DataAdapter.update...) how will that affect the performance 1
TableAdapter vs DataAdapter performance 3
DataAdapter.Update calling Insert Command with DbNull values 2
dataAdapter.Update() sql transactions 4
Error when updating database using the dataadapter.update method 5
DataAdapter.Update Problem 1
Dataadapter.Update fails intermittendly when updating large database 3

Back
Top