here is a comparison
I think IList is definitely faster (in performance) than DataTable. Here is an article with Pros and Cons... Hope that helps !
-Shiva
mycodetrip.com
myct
Last Activity: Dec 1 '08, 07:55 PM
Joined: Dec 1 '08
Location:
-
Have you looked at this Fast CSV Reader on codeproject ? The author Sebastien Lorion has tested it for performance...
-Shiva
mycodetrip.comLeave a comment:
-
Since you are using SQL 2005, once way (where you would have more control over the import) is to use write a CLR stored procedure, that will read the file using a StreamReader that loops through the file and treats each 3 lines (and multiples thereof) as a single record and inserts into the table.
If you go this way, remember you can use Context Connection = True to refer to the database that you are calling to CLR SP from...
...Leave a comment:
-
here is a solution for SQL2K and 2K5
Click here for a solution with code listing for both 2000 and 2005.
Hope that helps !
-Shiva
mycodetrip.comLeave a comment:
No activity results to display
Leave a comment: