ホーム>.NETソースコード>その他のカテゴリー
ダウンロード

EntityFrameWorkCore.sqlServer.SimpleBulks

SQLBulkCopyクラスを使用して、多数のレコードをデータベースに同期するのに役立つ非常にシンプルな.NETコアライブラリ。

概要

このライブラリは、entityFrameWorkCore dbcontextインスタンスdbcontextextensions.csで使用できるように、拡張メソッドを提供するか、 sqlconnextextensions.csを使用して、entityfameworkcoreを使用せずに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" ] ) ;

ダイナミックとラムダの両方の式を混ぜる必要がある場合に備えて、ビルダーアプローチを使用する

 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 ) ;

sqlconnextextensions

ラムダ式の使用

 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" ] ) ;

ダイナミックとラムダの両方の式を混ぜる必要がある場合に備えて、ビルダーアプローチを使用する

 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 ;
    } ) ;

bulkmatch 

 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
方法rowscount平均エラーGEN0 Gen1 Gen2割り当てられます
efcoreinsert 100 45.19ミリ秒Na - - - 985.52 kb
bulkinsert 100 32.68ミリ秒Na - - - 93.78 kb
efcoreinsert 1000 145.41 ms Na 1000.0000 - - 9702.7 kb
bulkinsert 1000 44.94ミリ秒Na - - - 573.84 kb
efcoreinsert 10000 788.90 ms Na 14000.0000 5000.0000 - 95727.38 kb
bulkinsert 10000 126.36ミリ秒Na - - - 5320.53 KB
efcoreinsert 100000 7,107.29 ms 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ミリ秒Na 365000.0000 87000.0000 - 2352262.34 kb
bulkinsert 250000 2,576.88ミリ秒Na 16000.0000 5000.0000 1000.0000 125832.63 KB
efcoreinsert 500000 34,957.34 ms Na 730000.0000 170000.0000 - 4711772.88 KB
bulkinsert 500000 5,553.61 ms 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
方法rowscount平均エラーGEN0 Gen1 Gen2割り当てられます
efcoreinsert 100 226.22 ms Na 1000.0000 - - 7438.51 kb
bulkinsert 100 48.38 ms Na - - - 444.18 kb
efcoreinsert 1000 566.95ミリ秒Na 11000.0000 4000.0000 - 73518.48 kb
bulkinsert 1000 125.77ミリ秒Na - - - 3460.21 kb
efcoreinsert 10000 6,268.42 ms Na 114000.0000 30000.0000 - 731076.92 kb
bulkinsert 10000 1,066.74 ms Na 5000.0000 2000.0000 1000.0000 33324.16 kb
efcoreinsert 100000 59,389.89 ms Na 1138000.0000 264000.0000 - 7282561.93 kb
bulkinsert 100000 9,504.12 ms 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
方法rowscount平均エラーGEN0 Gen1割り当てられます
efcoreupdate 100 61.65ミリ秒Na - - 853.66 kb
bulkupdate 100 27.33ミリ秒Na - - 63.55 kb
efcoreupdate 1000 143.39ミリ秒Na 1000.0000 - 8398.1 kb
bulkupdate 1000 43.95ミリ秒Na - - 379.25 kb
efcoreupdate 10000 685.97ミリ秒Na 12000.0000 3000.0000 82396.19 kb
bulkupdate 10000 182.54 ms Na - - 3499.74 kb
efcoreupdate 100000 8,495.18 ms Na 120000.0000 28000.0000 810248.07 KB
bulkupdate 100000 2,091.42 ms Na 5000.0000 1000.0000 33819.46 kb
efcoreupdate 250000 17,859.49 ms Na 300000.0000 69000.0000 2005895.77 KB
bulkupdate 250000 4,290.07ミリ秒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
方法rowscount平均エラーGEN0 Gen1割り当てられます
bulkupdate 500000 10.19 s Na 27000.0000 16000.0000 164.63 MB
bulkupdate 1000000 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
方法rowscount平均エラーGEN0 Gen1割り当てられます
efcoredelete 100 73.25 ms Na - - 681.09 kb
bulkdelete 100 29.42 ms Na - - 43.45 kb
efcoredelete 1000 176.83ミリ秒Na 1000.0000 1000.0000 6745 KB
bulkdelete 1000 27.19ミリ秒Na - - 236.86 kb
efcoredelete 10000 1,489.03 ms Na 10000.0000 2000.0000 66031.55 kb
bulkdelete 10000 431.74 ms Na - - 2150.99 KB
efcoredelete 20000 6,084.87ミリ秒Na 20000.0000 7000.0000 132403.3 kb
bulkdelete 20000 276.52 ms Na - - 4276.01 kb
efcoredelete 50000 39,933.60 ms Na 49000.0000 14000.0000 326164.25 kb
bulkdelete 50000 1,477.09 ms 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
方法rowscount平均エラーGEN0 Gen1割り当てられます
bulkdelete 100000 937.7 ms Na 3000.0000 1000.0000 20.67 MB
bulkdelete 250000 2,619.7ミリ秒Na 7000.0000 3000.0000 51.7 MB
bulkdelete 500000 4,897.7ミリ秒Na 13000.0000 6000.0000 103.22 MB
bulkdelete 1000000 9,466.0 ms 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
方法rowscount平均エラーGEN0 Gen1 Gen2割り当てられます
efcoreupsert 100 82.11 ms Na - - - 1840.23 kb
bulkmerge 100 34.27ミリ秒Na - - - 162.96 kb
efcoreupsert 1000 266.86ミリ秒Na 2000.0000 1000.0000 - 17984.91 KB
bulkmerge 1000 79.45ミリ秒Na - - - 1213.33 kb
efcoreupsert 10000 1,451.20 ms Na 26000.0000 8000.0000 - 178385.15 kb
bulkmerge 10000 677.47ミリ秒Na 1000.0000 - - 11679.42 kb
efcoreupsert 100000 13,902.06ミリ秒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
方法rowscount平均エラーGEN0 Gen1 Gen2割り当てられます
returndbgeneratedId 100 38.45ミリ秒Na - - - 151.09 kb
notreturndbgeneratedid 100 37.75 ms Na - - - 116.8 kb
returndbgeneratedId 1000 67.42 ms Na - - - 1099.48 kb
notreturndbgeneratedid 1000 60.02ミリ秒Na - - - 769.23 kb
returndbgeneratedId 10000 783.73ミリ秒Na 1000.0000 - - 10543.62 kb
notreturndbgeneratedid 10000 501.07 ms Na 1000.0000 - - 7348.79 KB
returndbgeneratedId 100000 3,187.89 ms Na 14000.0000 5000.0000 1000.0000 103878.09 kb
notreturndbgeneratedid 100000 2,741.31 ms 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
方法rowscount平均エラーGEN0 Gen1 Gen2割り当てられます
returndbgeneratedId 250000 7.799 s Na 32000.0000 8000.0000 - 249.8 MB
notreturndbgeneratedid 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
notreturndbgeneratedid 500000 14.328 s Na 47000.0000 14000.0000 - 355.19 MB
returndbgeneratedId 1000000 32.449 s Na 129000.0000 34000.0000 - 1003.67 MB
notreturndbgeneratedid 1000000 28.253 s Na 95000.0000 28000.0000 - 710.22 MB

bulkmatch

単一列/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
方法rowscount平均エラーGEN0 Gen1 Gen2割り当てられます
efcoreSelect 100 97.373ミリ秒Na - - - 1008.33 kb
efcoreBatchSelect 100 7.166ミリ秒Na - - - 94.77 KB
bulkmatch 100 8.570ミリ秒Na - - - 106.63 kb
efcoreSelect 1000 720.250ミリ秒Na 1000.0000 - - 9761.42 kb
efcoreBatchSelect 1000 6.375ミリ秒Na - - - 908.18 kb
bulkmatch 1000 15.445 ms Na - - - 820.36 kb
efcoreSelect 10000 8,075.686ミリ秒Na 15000.0000 1000.0000 - 97115.62 kb
efcoreBatchSelect 10000 66.438 ms Na 1000.0000 - - 9092.91 kb
bulkmatch 10000 69.430ミリ秒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
bulkmatch 100000 742.030 ms 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
方法rowscount平均エラーGEN0 Gen1 Gen2割り当てられます
efcoreBatchSelect 250000 2.101 s Na 26000.0000 11000.0000 1000.0000 224.05 MB
bulkmatch 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
bulkmatch 500000 4.507 s Na 62000.0000 24000.0000 1000.0000 404.03 MB
efcoreBatchSelect 1000000 8.523 s Na 103000.0000 38000.0000 1000.0000 898.44 MB
bulkmatch 1000000 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
方法rowscount平均エラーGEN0 Gen1割り当てられます
efcoreSelect 100 130.11 ms Na - - 1256.8 kb
bulkmatch 100 15.46ミリ秒Na - - 173.56 KB
efcoreSelect 1000 997.87ミリ秒Na 2000.0000 - 12373.85 kb
bulkmatch 1000 43.35 ms Na - - 1358.77 KB
efcoreSelect 10000 9,769.96 ms Na 20000.0000 4000.0000 123595.97 KB
bulkmatch 10000 238.80 ms Na 2000.0000 1000.0000 13768.49 kb
efcoreSelect 100000 89,204.16ミリ秒Na 201000.0000 51000.0000 1237424.23 kb
bulkmatch 100000 2,612.00ミリ秒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
方法rowscount平均エラーGEN0 Gen1割り当てられます
bulkmatch 250000 6.709 s Na 53000.0000 19000.0000 340.68 MB
bulkmatch 500000 12.939 s Na 107000.0000 36000.0000 683.46 MB
bulkmatch 1000000 25.418 s Na 214000.0000 74000.0000 1369.34 MB

誘惑可能

/src/entityframeworkcore.sqlserver.simplebulks.benchmarks/tempablebenchmarks.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
方法rowscount平均エラーGEN0 Gen1 Gen2割り当てられます
CreateTemptable 100 7.639ミリ秒Na - - - 68.03 kb
CreateTemptable 1000 14.077ミリ秒Na - - - 373.76 kb
CreateTemptable 10000 89.789ミリ秒Na - - - 3455.46 kb
CreateTemptable 100000 574.937ミリ秒Na 4000.0000 1000.0000 - 34081.95 kb
CreateTemptable 250000 1,403.071 ms Na 12000.0000 5000.0000 1000.0000 85229.91 kb
CreateTemptable 500000 2,838.562 ms Na 22000.0000 8000.0000 1000.0000 170241.85 kb
CreateTemptable 1000000 6,198.206ミリ秒Na 43000.0000 14000.0000 1000.0000 340282.7 kb

ライセンス

EntityFrameWorkCore.sqlServer.SimpleBulksは、MITライセンスに基づいてライセンスされています。

拡大する
追加情報
関連アプリ
おすすめ
関連情報 すべて