How to Optimize DbTransactions (C#) with SQLServer ?

[kadaoui el mehdi]

Hello, I have to Update a Csv file into Sql Server DataBase, the file contains 200 000 records. So how can i do to optimize the DbTransactions ?! because 200 000 is too big and i want not overload the Database Server. Solution1: create a global DbTransaction with IsolationLevel=RaadUncommited Solution2: create a DbTransaction foreach Record with IsolationLevel=RaadUncommited Solution3: create a DbTransaction for a group of Records with IsolationLevel=RaadUncommited Already Thanks.

[Enver Maroshi]

What do you mean by "update" csv into database? You update records in place, or insert new ones? Look at BULK INSERT at MSDN. It is very fast, you can insert all in temp table and then update records, if that is your goal.

[kadaoui el mehdi]

thank you for you answer. I update a record. I know the BULK INSERT but the CSV file have to be in the same machine of Sql Server Data base!

[Niladri_Biswas]

Check out the following two articles. These are the best practices, I believe 1) http://www.sqlnetframework.com/DataAccessBlog/post/2008/11/07/Bulk-insert-in-SQL-Server-2005-using-ADONET-and-XML.aspx[^] 2) http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/[^] Hope this helps :)

Niladri Biswas