Insert data into SQL server with better performance

I have an application that makes heavy use of DB (SQL Server).

Since it should have high performance, I would like to know the fastest way to insert a record into DB.Fastest in terms of runtime.

What should i use?

As I know, the fastest way is to create a stored procedure and call it from code (ADO.NET). Please let me know if there is any better way or maybe there are some other methods to improve performance.

+3
source share
4 answers

, , - , .

  • . , .
  • , . .
  • : / .
  • , - , winform UI, , .
  • , , .
  • , , , ... .
+1

, , , SqlBulkCopy

+3

" ".

  • ?
  • ?
  • ?
  • - ( ) - - ?

, , , . SQL Server, . , SSIS, , "" , . , , .

+2

? 2M/ = 83k/hour = 1388/min = 23/second.

23 SQL Server .

0

Source: https://habr.com/ru/post/1744826/


All Articles