DataAdapter update

  • Thread starter Thread starter Ruslan Shlain
  • Start date Start date
R

Ruslan Shlain

Not sure who to ask about this so,
I have an app that grabs data from flat file and populates a dataset with
it. Then using update method of a DataAdapter I insert all that data in to
the SQL Server table.
I have a separate app, console app for now, that monitors queue table and
starts my other app to read the file and insert it in to the DB. Some times
I need to have 5 of the update apps running at the same time. When update
app runs in single instance it inserts very fast, but if I have more then
one instance it slows down dramatically.

I want to speed it up and I am not sure if it is possible. Does SQL Server
locks the table when you use such mechanism as DataAdapted update command?

What's the reason performance drops dramatically.
 
I don't know, but if you create the DataAdapter with VisualStudio, you have
by the query textarea an advance options button, I remove always the full
parallelism checkbox.
 
Back
Top