LINQ to SQL - Seriously SLOW?!?!

[NewsBot]

Hey everyone.

 

I decoded to write a little test app to compare the speed of DataSet / Table adapter to 'LINQ to SQL'.

 

This test focused solely on inserts

 

The app loops 10,000 times, inserting a row into a datatable (or in LTS, it adds the row to the table equivalent in the DataContext)

 

Results

=====

 

 

It took the code 293 ms to load the rows into the DataTable, and then 16030ms to update the database using the tableadapter.

 

It took 474ms to load the rows into the datacontext, and then a whopping 29550ms to complete the .SubmitChanges()

 

 

How can this be, I was expecting LTS to win hands down,but for now it looks like I'll be sticking to my datasets!

 

More...

 

View All Our Microsoft Related Feeds