홈페이지>.NET 소스 코드>기타 카테고리
다운로드

EntityFrameworkCore.sqlserver.simplebulks

SQLBULKCOPY 클래스를 사용하여 많은 수의 레코드를 데이터베이스에 동기화하는 데 도움이되는 매우 간단한 .NET Core 라이브러리.

개요

이 라이브러리는 EntityFrameWorkCore DBContext 인스턴스 DBCONTEXTEXTENSIONS.CS 와 함께 사용할 수 있도록 확장 메소드를 제공하거나 EntityFrameworkCore 를 사용하지 않고 SQLConnection 인스턴스 와 직접 작업 할 수 있습니다.

너겟

https://www.nuget.org/packages/entityframeworkcore.sqlserver.simplebulks

특징

  • 벌크 삽입
  • 대량 업데이트
  • 벌크 삭제
  • 벌크 병합
  • 벌크 일치
  • 임시 테이블
  • 직접 삽입
  • 직접 업데이트
  • 직접 삭제

예

EntityFrameworkCore.sqlserver.simplebulks.demo

  • 연결 문자열 업데이트 : 
     private const string _connectionString = "Server=.;Database=SimpleBulks;User Id=xxx;Password=xxx" ;
  • 빌드 및 실행.

DBCONTEXTEXTENSIONS

람다 표현을 사용합니다 

 using EntityFrameworkCore . SqlServer . SimpleBulks . BulkDelete ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkInsert ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkMerge ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkUpdate ;

// Insert all columns
dbct . BulkInsert ( rows ) ;
dbct . BulkInsert ( compositeKeyRows ) ;

// Insert selected columns only
dbct . BulkInsert ( rows ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ) ;
dbct . BulkInsert ( compositeKeyRows ,
    row => new { row . Id1 , row . Id2 , row . Column1 , row . Column2 , row . Column3 } ) ;

dbct . BulkUpdate ( rows ,
    row => new { row . Column3 , row . Column2 } ) ;
dbct . BulkUpdate ( compositeKeyRows ,
    row => new { row . Column3 , row . Column2 } ) ;

dbct . BulkMerge ( rows ,
    row => row . Id ,
    row => new { row . Column1 , row . Column2 } ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ) ;
dbct . BulkMerge ( compositeKeyRows ,
    row => new { row . Id1 , row . Id2 } ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ,
    row => new { row . Id1 , row . Id2 , row . Column1 , row . Column2 , row . Column3 } ) ;
                        
dbct . BulkDelete ( rows ) ;
dbct . BulkDelete ( compositeKeyRows ) ;

동적 문자열 사용 

 using EntityFrameworkCore . SqlServer . SimpleBulks . BulkDelete ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkInsert ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkMerge ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkUpdate ;

dbct . BulkUpdate ( rows ,
    [ "Column3" , "Column2" ] ) ;
dbct . BulkUpdate ( compositeKeyRows ,
    [ "Column3" , "Column2" ] ) ;

dbct . BulkMerge ( rows ,
    "Id" ,
    [ "Column1" , "Column2" ] ,
    [ "Column1" , "Column2" , "Column3" ] ) ;
dbct . BulkMerge ( compositeKeyRows ,
    [ "Id1" , "Id2" ] ,
    [ "Column1" , "Column2" , "Column3" ] ,
    [ "Id1" , "Id2" , "Column1" , "Column2" , "Column3" ] ) ;

Dynamic & Lambda Expression을 모두 혼합 해야하는 경우 빌더 접근법 사용 

 new BulkInsertBuilder < Row > ( dbct . GetSqlConnection ( ) )
	. WithColumns ( row => new { row . Column1 , row . Column2 , row . Column3 } )
	// or .WithColumns([ "Column1", "Column2", "Column3" ])
	. WithOutputId ( row => row . Id )
	// or .WithOutputId("Id")
	. ToTable ( dbct . GetTableName ( typeof ( Row ) ) )
	// or .ToTable("Rows")
	. Execute ( rows ) ;

sqlconnectionextensions

람다 표현을 사용합니다 

 using EntityFrameworkCore . SqlServer . SimpleBulks . BulkDelete ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkInsert ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkMerge ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkUpdate ;

// Register Type - Table Name globaly
TableMapper . Register ( typeof ( Row ) , "Rows" ) ;
TableMapper . Register ( typeof ( CompositeKeyRow ) , "CompositeKeyRows" ) ;

connection . BulkInsert ( rows ,
           row => new { row . Column1 , row . Column2 , row . Column3 } ) ;
connection . BulkInsert ( compositeKeyRows ,
           row => new { row . Id1 , row . Id2 , row . Column1 , row . Column2 , row . Column3 } ) ;

connection . BulkUpdate ( rows ,
           row => row . Id ,
           row => new { row . Column3 , row . Column2 } ) ;
connection . BulkUpdate ( compositeKeyRows ,
           row => new { row . Id1 , row . Id2 } ,
           row => new { row . Column3 , row . Column2 } ) ;

connection . BulkMerge ( rows ,
           row => row . Id ,
           row => new { row . Column1 , row . Column2 } ,
           row => new { row . Column1 , row . Column2 , row . Column3 } ) ;
connection . BulkMerge ( compositeKeyRows ,
           row => new { row . Id1 , row . Id2 } ,
           row => new { row . Column1 , row . Column2 , row . Column3 } ,
           row => new { row . Id1 , row . Id2 , row . Column1 , row . Column2 , row . Column3 } ) ;
                        
connection . BulkDelete ( rows , row => row . Id ) ;
connection . BulkDelete ( compositeKeyRows , row => new { row . Id1 , row . Id2 } ) ;

동적 문자열 사용 

 using EntityFrameworkCore . SqlServer . SimpleBulks . BulkDelete ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkInsert ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkMerge ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkUpdate ;

connection . BulkInsert ( rows , "Rows" ,
           [ "Column1" , "Column2" , "Column3" ] ) ;
connection . BulkInsert ( rows . Take ( 1000 ) , "Rows" ,
           typeof ( Row ) . GetDbColumnNames ( "Id" ) ) ;
connection . BulkInsert ( compositeKeyRows , "CompositeKeyRows" ,
           [ "Id1" , "Id2" , "Column1" , "Column2" , "Column3" ] ) ;

connection . BulkUpdate ( rows , "Rows" ,
           "Id" ,
           [ "Column3" , "Column2" ] ) ;
connection . BulkUpdate ( compositeKeyRows , "CompositeKeyRows" ,
           [ "Id1" , "Id2" ] ,
           [ "Column3" , "Column2" ] ) ;

connection . BulkMerge ( rows , "Rows" ,
           "Id" ,
           [ "Column1" , "Column2" ] ,
           [ "Column1" , "Column2" , "Column3" ] ) ;
connection . BulkMerge ( compositeKeyRows , "CompositeKeyRows" ,
           [ "Id1" , "Id2" ] ,
           [ "Column1" , "Column2" , "Column3" ] ,
           [ "Id1" , "Id2" , "Column1" , "Column2" , "Column3" ] ) ;

connection . BulkDelete ( rows , "Rows" , "Id" ) ;
connection . BulkDelete ( compositeKeyRows , "CompositeKeyRows" , [ "Id1" , "Id2" ] ) ;

Dynamic & Lambda Expression을 모두 혼합 해야하는 경우 빌더 접근법 사용 

 new BulkInsertBuilder < Row > ( connection )
	. WithColumns ( row => new { row . Column1 , row . Column2 , row . Column3 } )
	// or .WithColumns([ "Column1", "Column2", "Column3" ])
	. WithOutputId ( row => row . Id )
	// or .WithOutputId("Id")
	. ToTable ( "Rows" )
	. Execute ( rows ) ;

구성

Bulkinsert 

 _context . BulkInsert ( rows ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ,
    options =>
    {
        options . KeepIdentity = false ;
        options . BatchSize = 0 ;
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

Bulkupdate 

 _context . BulkUpdate ( rows ,
    row => new { row . Column3 , row . Column2 } ,
    options =>
    {
        options . BatchSize = 0 ;
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

bulkdelete 

 _context . BulkDelete ( rows ,
    options =>
    {
        options . BatchSize = 0 ;
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

Bulkmerge 

 _context . BulkMerge ( rows ,
    row => row . Id ,
    row => new { row . Column1 , row . Column2 } ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ,
    options =>
    {
        options . BatchSize = 0 ;
        options . Timeout = 30 ;
        options . WithHoldLock = false ;
        options . ReturnDbGeneratedId = true ;
        options . LogTo = Console . WriteLine ;
    } ) ;

벌크 매치 

 var contactsFromDb = _context . BulkMatch ( matchedContacts ,
    x => new { x . CustomerId , x . CountryIsoCode } ,
    options =>
    {
        options . BatchSize = 0 ;
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

유혹 가능 

 var customerTableName = _context . CreateTempTable ( customers ,
    x => new
    {
        x . IdNumber ,
        x . FirstName ,
        x . LastName ,
        x . CurrentCountryIsoCode
    } ,
    options =>
    {
        options . BatchSize = 0 ;
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

DirectInsert 

 _context . DirectInsert ( row ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ,
    options =>
    {
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

DirectUpdate 

 _context . DirectUpdate ( row ,
    row => new { row . Column3 , row . Column2 } ,
    options =>
    {
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

DirectDelete 

 _context . DirectDelete ( row ,
    options =>
    {
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

반환 된 결과

Bulkupdate 

 var updateResult = dbct . BulkUpdate ( rows , row => new { row . Column3 , row . Column2 } ) ;

Console . WriteLine ( $ "Updated: { updateResult . AffectedRows } row(s)" ) ;

bulkdelete 

 var deleteResult = dbct . BulkDelete ( rows ) ;

Console . WriteLine ( $ "Deleted: { deleteResult . AffectedRows } row(s)" ) ;

Bulkmerge 

 var mergeResult = dbct . BulkMerge ( rows ,
    row => row . Id ,
    row => new { row . Column1 , row . Column2 } ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ) ;

Console . WriteLine ( $ "Updated: { mergeResult . UpdatedRows } row(s)" ) ;
Console . WriteLine ( $ "Inserted: { mergeResult . InsertedRows } row(s)" ) ;
Console . WriteLine ( $ "Affected: { mergeResult . AffectedRows } row(s)" ) ;

벤치 마크

Bulkinsert

단일 테이블 /src/entityframeworkcore.sqlserver.simplebulks.benchmarks/bulkinsertsingletablebenchmarks.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 gen2 할당
efcoreinsert 100 45.19ms NA - - - 985.52 KB
Bulkinsert 100 32.68ms NA - - - 93.78 KB
efcoreinsert 1000 145.41 ms NA 1000.0000 - - 9702.7 KB
Bulkinsert 1000 44.94ms NA - - - 573.84 KB
efcoreinsert 10000 788.90ms NA 14000.0000 5000.0000 - 95727.38 KB
Bulkinsert 10000 126.36ms NA - - - 5320.53 KB
efcoreinsert 100000 7,107.29ms NA 146000.0000 36000.0000 - 950162.56 KB
Bulkinsert 100000 998.42 ms NA 7000.0000 3000.0000 1000.0000 51730.81 KB
efcoreinsert 250000 18,542.56 ms NA 365000.0000 87000.0000 - 2352262.34 KB
Bulkinsert 250000 2,576.88ms NA 16000.0000 5000.0000 1000.0000 125832.63 KB
efcoreinsert 500000 34,957.34ms NA 730000.0000 170000.0000 - 4711772.88 KB
Bulkinsert 500000 5,553.61ms NA 30000.0000 9000.0000 1000.0000 252707.77 KB

다중 테이블 (1x 부모 행 + 5x 하위 행) /src/entityframeworkcore.sqlserver.simplebulks.benchmarks/bulkinsertmultipletablesbenchmarks.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 gen2 할당
efcoreinsert 100 226.22ms NA 1000.0000 - - 7438.51 KB
Bulkinsert 100 48.38ms NA - - - 444.18 KB
efcoreinsert 1000 566.95ms NA 11000.0000 4000.0000 - 73518.48 KB
Bulkinsert 1000 125.77ms NA - - - 3460.21 KB
efcoreinsert 10000 6,268.42ms NA 114000.0000 30000.0000 - 731076.92 KB
Bulkinsert 10000 1,066.74ms NA 5000.0000 2000.0000 1000.0000 33324.16 KB
efcoreinsert 100000 59,389.89ms NA 1138000.0000 264000.0000 - 7282561.93 KB
Bulkinsert 100000 9,504.12ms NA 39000.0000 13000.0000 1000.0000 327100.08 KB

Bulkupdate

/src/entityframeworkcore.sqlserver.simplebulks.benchmarks/bulkupdatebenchmarks.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 할당
efcoreupdate 100 61.65ms NA - - 853.66 KB
Bulkupdate 100 27.33 MS NA - - 63.55 KB
efcoreupdate 1000 143.39ms NA 1000.0000 - 8398.1 KB
Bulkupdate 1000 43.95ms NA - - 379.25 KB
efcoreupdate 10000 685.97 ms NA 12000.0000 3000.0000 82396.19 KB
Bulkupdate 10000 182.54ms NA - - 3499.74 KB
efcoreupdate 100000 8,495.18ms NA 120000.0000 28000.0000 810248.07 KB
Bulkupdate 100000 2,091.42ms NA 5000.0000 1000.0000 33819.46 KB
efcoreupdate 250000 17,859.49ms NA 300000.0000 69000.0000 2005895.77 KB
Bulkupdate 250000 4,290.07ms NA 13000.0000 7000.0000 84352 KB 
 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 할당
Bulkupdate 500000 10.19 s NA 27000.0000 16000.0000 164.63 MB
Bulkupdate 10000000 17.03 s NA 54000.0000 37000.0000 329.12 MB

bulkdelete

/src/entityframeworkcore.sqlserver.simplebulks.benchmarks/bulkdeletebenchmarks.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 할당
efcoredelete 100 73.25ms NA - - 681.09 KB
bulkdelete 100 29.42ms NA - - 43.45 KB
efcoredelete 1000 176.83 MS NA 1000.0000 1000.0000 6745 KB
bulkdelete 1000 27.19ms NA - - 236.86 KB
efcoredelete 10000 1,489.03ms NA 10000.0000 2000.0000 66031.55 KB
bulkdelete 10000 431.74 ms NA - - 2150.99 KB
efcoredelete 20000 6,084.87 ms NA 20000.0000 7000.0000 132403.3 KB
bulkdelete 20000 276.52ms NA - - 4276.01 KB
efcoredelete 50000 39,933.60ms NA 49000.0000 14000.0000 326164.25 KB
bulkdelete 50000 1,477.09ms NA 1000.0000 - 10594.63 KB 
 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 할당
bulkdelete 100000 937.7ms NA 3000.0000 1000.0000 20.67 MB
bulkdelete 250000 2,619.7ms NA 7000.0000 3000.0000 51.7 MB
bulkdelete 500000 4,897.7ms NA 13000.0000 6000.0000 103.22 MB
bulkdelete 10000000 9,466.0ms NA 26000.0000 12000.0000 206.28 MB

Bulkmerge

/src/entityframeworkcore.sqlserver.simplebulks.benchmarks/bulkmergebenchmarks.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 gen2 할당
efcoreupsert 100 82.11ms NA - - - 1840.23 KB
Bulkmerge 100 34.27ms NA - - - 162.96 KB
efcoreupsert 1000 266.86 ms NA 2000.0000 1000.0000 - 17984.91 KB
Bulkmerge 1000 79.45ms NA - - - 1213.33 KB
efcoreupsert 10000 1,451.20ms NA 26000.0000 8000.0000 - 178385.15 KB
Bulkmerge 10000 677.47ms NA 1000.0000 - - 11679.42 KB
efcoreupsert 100000 13,902.06 ms NA 266000.0000 63000.0000 - 1762696.52 KB
Bulkmerge 100000 3,415.31 ms NA 16000.0000 6000.0000 1000.0000 115233.2 KB
efcoreupsert 250000 36,167.51 ms NA 665000.0000 152000.0000 - 4362872.57 KB
Bulkmerge 250000 7,681.71 ms NA 37000.0000 11000.0000 1000.0000 284187.09 KB

/src/entityframeworkcore.sqlserver.simplebulks.benchmarks/bulkmergereturndbgeneratedidbenchmarks.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 gen2 할당
returndbgeneratedid 100 38.45ms NA - - - 151.09 KB
NOTERTURNDBGENERATEDID 100 37.75ms NA - - - 116.8 KB
returndbgeneratedid 1000 67.42ms NA - - - 1099.48 KB
NOTERTURNDBGENERATEDID 1000 60.02ms NA - - - 769.23 KB
returndbgeneratedid 10000 783.73 MS NA 1000.0000 - - 10543.62 KB
NOTERTURNDBGENERATEDID 10000 501.07 ms NA 1000.0000 - - 7348.79 KB
returndbgeneratedid 100000 3,187.89ms NA 14000.0000 5000.0000 1000.0000 103878.09 KB
NOTERTURNDBGENERATEDID 100000 2,741.31ms NA 11000.0000 5000.0000 1000.0000 72936.01 KB 
 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 gen2 할당
returndbgeneratedid 250000 7.799 s NA 32000.0000 8000.0000 - 249.8 MB
NOTERTURNDBGENERATEDID 250000 6.619 s NA 24000.0000 7000.0000 - 177.7 MB
returndbgeneratedid 500000 15.051 s NA 66000.0000 19000.0000 1000.0000 500.64 MB
NOTERTURNDBGENERATEDID 500000 14.328 s NA 47000.0000 14000.0000 - 355.19 MB
returndbgeneratedid 10000000 32.449 s NA 129000.0000 34000.0000 - 1003.67 MB
NOTERTURNDBGENERATEDID 10000000 28.253 s NA 95000.0000 28000.0000 - 710.22 MB

벌크 매치

단일 열 /src/entityframeworkcore.sqlserver.simplebulks.benchmarks/bulkmatchsinglecolumnbenchmarks.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 gen2 할당
efcoreselect 100 97.373 MS NA - - - 1008.33 KB
efcorebatchSelect 100 7.166 MS NA - - - 94.77 KB
벌크 매치 100 8.570ms NA - - - 106.63 KB
efcoreselect 1000 720.250ms NA 1000.0000 - - 9761.42 KB
efcorebatchSelect 1000 6.375ms NA - - - 908.18 KB
벌크 매치 1000 15.445ms NA - - - 820.36 KB
efcoreselect 10000 8,075.686 ms NA 15000.0000 1000.0000 - 97115.62 KB
efcorebatchSelect 10000 66.438 ms NA 1000.0000 - - 9092.91 KB
벌크 매치 10000 69.430ms NA 1000.0000 - - 8177.76 KB
efcoreselect 100000 81,088.718 ms NA 159000.0000 31000.0000 1000.0000 972204.7 KB
efcorebatchSelect 100000 920.412 ms NA 11000.0000 4000.0000 1000.0000 91808.56 KB
벌크 매치 100000 742.030ms NA 13000.0000 6000.0000 1000.0000 82419.43 KB 
 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 gen2 할당
efcorebatchSelect 250000 2.101 s NA 26000.0000 11000.0000 1000.0000 224.05 MB
벌크 매치 250000 2.067 s NA 32000.0000 12000.0000 1000.0000 201.64 MB
efcorebatchSelect 500000 4.239 s NA 53000.0000 20000.0000 2000.0000 448.85 MB
벌크 매치 500000 4.507 s NA 62000.0000 24000.0000 1000.0000 404.03 MB
efcorebatchSelect 10000000 8.523 s NA 103000.0000 38000.0000 1000.0000 898.44 MB
벌크 매치 10000000 11.585 s NA 123000.0000 46000.0000 1000.0000 808.82 MB

다중 열 /src/entityframeworkcore.sqlserver.simplebulks.benchmarks/bulkmatchmultiplecolumnsbenchmarks.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 할당
efcoreselect 100 130.11ms NA - - 1256.8 KB
벌크 매치 100 15.46ms NA - - 173.56 KB
efcoreselect 1000 997.87 ms NA 2000.0000 - 12373.85 KB
벌크 매치 1000 43.35ms NA - - 1358.77 KB
efcoreselect 10000 9,769.96ms NA 20000.0000 4000.0000 123595.97 KB
벌크 매치 10000 238.80ms NA 2000.0000 1000.0000 13768.49 KB
efcoreselect 100000 89,204.16 ms NA 201000.0000 51000.0000 1237424.23 KB
벌크 매치 100000 2,612.00ms NA 21000.0000 8000.0000 138686.52 KB 
 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 할당
벌크 매치 250000 6.709 s NA 53000.0000 19000.0000 340.68 MB
벌크 매치 500000 12.939 s NA 107000.0000 36000.0000 683.46 MB
벌크 매치 10000000 25.418 s NA 214000.0000 74000.0000 1369.34 MB

유혹 가능

/src/entityframeworkcore.sqlserver.simplebulks.benchmarks/temptablebenchmarks.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
방법 로우 스카운 평균 오류 gen0 gen1 gen2 할당
CreateTembent 100 7.639ms NA - - - 68.03 KB
CreateTembent 1000 14.077 ms NA - - - 373.76 KB
CreateTembent 10000 89.789ms NA - - - 3455.46 KB
CreateTembent 100000 574.937 MS NA 4000.0000 1000.0000 - 34081.95 KB
CreateTembent 250000 1,403.071 ms NA 12000.0000 5000.0000 1000.0000 85229.91 KB
CreateTembent 500000 2,838.562ms NA 22000.0000 8000.0000 1000.0000 170241.85 KB
CreateTembent 10000000 6,198.206 ms NA 43000.0000 14000.0000 1000.0000 340282.7 KB

특허

EntityFrameworkCore.sqlserver.simplebulks 는 MIT 라이센스에 따라 라이센스가 부여됩니다.

확장하다
추가 정보
관련 애플리케이션
추천
관련 정보 전체