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