C# and SQL Server: Parallel vs. Sequential Writes (?)
in [Programming SQL]
|
Prev: PHP Tutorials
Next: Reservered Words
From: Bob Barrows on 19 Feb 2010 11:51 Andy O'Neill wrote: > Depending on WHY there are 8000 changed records sitting around in > memory on the client machine. Very good point. what if that machine crashes before it has a chance to insert these records into the database ... ? I can't imagine a very happy user. -- HTH, Bob Barrows
From: Kimbo Slice on 19 Feb 2010 13:05 ha! No the records aren't created by some dude typing them in. They're statistical information created by the C# app. The 8,000 statistical rows don't really take that long to calculate (less than 15 secs). It's the upload to the database that lags. If the process crashes, I just restart the calculation. David "Bob Barrows" <reb01501(a)NOyahoo.SPAMcom> wrote in message news:OBhA7OYsKHA.1352(a)TK2MSFTNGP06.phx.gbl... > Andy O'Neill wrote: >> Depending on WHY there are 8000 changed records sitting around in >> memory on the client machine. > > Very good point. what if that machine crashes before it has a chance to > insert these records into the database ... ? > I can't imagine a very happy user. > > -- > HTH, > Bob Barrows > >
From: Andy O'Neill on 19 Feb 2010 13:21 "Kimbo Slice" <Jules.Winfield(a)newsgroup.nospam> wrote in message news:B6CdnQgupvp5T-PWnZ2dnUVZ_rGdnZ2d(a)giganews.com... > ha! > > No the records aren't created by some dude typing them in. They're > statistical information created by the C# app. The 8,000 statistical rows > don't really take that long to calculate (less than 15 secs). It's the > upload to the database that lags. > > If the process crashes, I just restart the calculation. > > David We're still missing at least one relevent piece of the puzzle.
From: Kimbo Slice on 25 Feb 2010 19:59
I wanted to follow up in case anyone comes across this thread looking for answers... The most efficient way to upload a huge number of dynamically generated rows from a client application to SQL Server is to use SqlDataAdapter, setting the 'UpdateBatchSize' property to zero. You can read more info here: http://blogs.msdn.com/dataaccess/archive/2005/05/19/420065.aspx |