Inserting Multiple Records in SQL2000
Posted
by Chris M
on Stack Overflow
See other posts from Stack Overflow
or by Chris M
Published on 2010-04-16T09:37:06Z
Indexed on
2010/04/16
9:43 UTC
Read the original article
Hit count: 374
I have a web app that currently is inserting x (between 1 + 40) records into a table that contains about 5 fields, via a linq-2-sql-stored procedure in a loop.
Would it be better to manually write the SQL Inserts to say a string builder and run them against the database when the loops completed rather than 30 transactions? or should I just accept this is negligible for such a small number of inserts.
© Stack Overflow or respective owner