By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,449 Members | 1,601 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,449 IT Pros & Developers. It's quick & easy.

DataAdapter update

P: n/a
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.

--
Ruslan Shlain
nAlliance Corporation
www.nAlliance.com
Nov 15 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
"Ruslan Shlain" <rs*****@hotmail.com> schrieb im Newsbeitrag
news:OW**************@TK2MSFTNGP09.phx.gbl...
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.

--
Ruslan Shlain
nAlliance Corporation
www.nAlliance.com

Nov 15 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.