SQL Insert Performance
Posted on 2008-02-04
in a c# application I have a Datatable (with 35 columns, some varchar(>30), some DateTime and one Decimal) with 1565 rows (all rows are with state added, cause they are all news, created reading a text file containing data in NOT well formatted text - so bulk insert is impossible -). When I want to update data to SQL server express, I call DataSet.Update(DataTable). The insertion of 1565 rows takes about 40 seconds (on my 2400 QuadCore).
I cannot understand if performance are good. Does it take too long or is normal this way? How can I improve performance? Thanx in advance