ADO.NET DataAdapter.Update taking forever
Hi. I'm using SQL Server Compact Edition with Ado.net and have a serious performace issue I'd like to clear up.
The problem in it's simplest form is that I load say 2,000 rows from a table in the database (which may contain many thousands of rows) into a DataTable. I then select a bunch of these (say 1500) that meet some criteria and Delete() them via their DataRow objects. Note that this all happens relatively quickly.
When I then call DataAdapter.Upd ate( DataTable ), it takes something like 10 or 12 seconds just to do the Update! This is unacceptable as it is interfering with the responsiveness of my application.
Does anyone have any suggestions for ways to improve this?
The problem in it's simplest form is that I load say 2,000 rows from a table in the database (which may contain many thousands of rows) into a DataTable. I then select a bunch of these (say 1500) that meet some criteria and Delete() them via their DataRow objects. Note that this all happens relatively quickly.
When I then call DataAdapter.Upd ate( DataTable ), it takes something like 10 or 12 seconds just to do the Update! This is unacceptable as it is interfering with the responsiveness of my application.
Does anyone have any suggestions for ways to improve this?