I have a .NET application that is merging two datatables with a lot of rows (10,000+). There is a good chance of having a large number of update/inserts to perform to the SQL table when using the DataAdapter.Update command. Right now, I have the Adapter UpdateBatchSize property set to 200. VS warns against setting this value too high ...
I am running into a problem when setting the UpdateBatchSize property to a number > 1 on my data adapter. I only get an error when I have a very specific type of DataRelationship on the table. Consider: Table JobProductColorSize Columns: Id : long //is a primary key ParentAssemblyId : long? Therefore I have a DataRelation created ...
Hi there, I've finally gotten my insert batch to work and now I've been fiddling with the size of the batch, but I can't see any difference in performance between a value of 50 and a value of 10000. This seems very odd to me, but I don't know what's happening behind the scene, so it might be normal behavior. I'm inserting 160k rows int...