DataAdapter update

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ruslan Shlain (rshlain_at_hotmail.com)
Date: 02/05/04 

Date: Thu, 5 Feb 2004 13:42:01 -0600

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

Relevant Pages

  • SQL db or Flat File storage option
    ... Let's say I have a stand alone app that was conceived/created decades ... the user submits the data for batch processing ... SQL is transformed into the same positional flat file as in the legacy ... ado.net and SQL server but am meeting resistance. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL db or Flat File storage option
    ... > application with the data stored in a positional flat file. ... > call this the legacy app. ... > SQL is transformed into the same positional flat file as in the legacy ... > ado.net and SQL server but am meeting resistance. ...
    (microsoft.public.dotnet.framework.adonet)
  • DataAdapter update
    ... I have an app that grabs data from flat file and populates a dataset with ... nAlliance Corporation ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Import flat file: CSV, etc.
    ... what's the best way to import a flat file to a .NET 3.5 App? ... Adrian Miller ... text qualifiers, any special processing requirements, etc. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Threading resulting in worse perfomance. Can COM be the cause ?
    ... A COM object can run as a Singleton -- a single instance, so even though you have multiple threads, you are all calling the same instance; ... I've written a little app to process OLAP partitions on an Analysis Services 2000 database. ... I've been trying to multi-thread it to improve the overall through-put. ...
    (microsoft.public.dotnet.general)