Insert data into SQL server with best performance

Posted by Incognito on Stack Overflow See other posts from Stack Overflow or by Incognito
Published on 2010-05-10T18:33:44Z Indexed on 2010/05/11 1:04 UTC
Read the original article Hit count: 279

I have an application which intensively uses DB (SQL Server).

As it must have high performance I would like to know the fastest way to insert record into DB.Fastest from the standpoint of execution time.

What should I use ?

As I know the fastest way is to create stored procedure and to call it from code (ADO.NET). Please let me know is there any better way or may be there are is some other practices to increase performance.

© Stack Overflow or respective owner

Related posts about c#

Related posts about .NET