Benchmark History

[shps951023]

20210712 Benchmark :

Log

MiniExcelLibs.Benchmarks.XlsxBenchmark-20210712-171922.log

Version

    <PackageReference Include="BenchmarkDotNet" Version="0.12.1" />
    <PackageReference Include="ClosedXML" Version="0.95.4" />
    <PackageReference Include="ClosedXML.Report" Version="0.2.1" />
    <PackageReference Include="DocumentFormat.OpenXml" Version="2.12.3" />
    <PackageReference Include="EPPlus" Version="5.6.1" />
    <PackageReference Include="ExcelDataReader" Version="3.6.0" />
    <PackageReference Include="MiniExcel" Version="0.17.2" />

Environment

BenchmarkDotNet=v0.12.1, OS=Windows 10.0.19042
Intel Core i7-7700 CPU 3.60GHz (Kaby Lake), 1 CPU, 8 logical and 4 physical cores
.NET Core SDK=5.0.204
  [Host]   : .NET Core 3.1.16 (CoreCLR 4.700.21.26205, CoreFX 4.700.21.26205), X64 RyuJIT
  ShortRun : .NET Core 3.1.16 (CoreCLR 4.700.21.26205, CoreFX 4.700.21.26205), X64 RyuJIT

MaxMemory:

Create/Export

MiniExcel

OpenXmlSdk By Dom

Epplus

Result

Method	Mean	StdDev	Error	Gen 0	Gen 1	Gen 2	Allocated Summary Memory
'MiniExcel QueryFirst'	257.2 μs	2.77 μs	50.55 μs	10.7422	5.2083	0.3255	44.7 KB
'ExcelDataReader QueryFirst'	8,359,231.9 μs	15,505.06 μs	282,869.98 μs	581000.0000	833.3333	-	2373460.68 KB
'MiniExcel Query'	11,491,739.1 μs	18,439.47 μs	336,404.61 μs	579666.6667	1000.0000	-	2367493.12 KB
'MiniExcel Create Xlsx'	14,114,751.1 μs	51,185.77 μs	933,819.05 μs	1294666.6667	1333.3333	-	5287530.65 KB
'ExcelDataReader Query'	16,809,390.3 μs	65,163.97 μs	1,188,833.35 μs	1240666.6667	1666.6667	166.6667	5067127.75 KB
'Epplus QueryFirst'	18,688,411.9 μs	23,829.36 μs	434,736.17 μs	622333.3333	200833.3333	4333.3333	4902326.72 KB
'Epplus Create Xlsx'	22,362,969.8 μs	650,558.48 μs	11,868,608.52 μs	1040166.6667	19000.0000	7166.6667	5753420.42 KB
'Epplus Query'	22,376,877.8 μs	22,471.63 μs	409,966.27 μs	1539166.6667	203666.6667	5166.6667	8643843.82 KB
'MiniExcel Template Generate'	33,620,123.9 μs	118,471.82 μs	2,161,366.96 μs	7688166.6667	8000.0000	2833.3333	31914169.63 KB
'OpenXmlSdk Create xlsx by DOM mode'	51,204,642.7 μs	2,973,552.72 μs	54,248,671.11 μs	904500.0000	305500.0000	12500.0000	7026068.04 KB
'ClosedXml QueryFirst'	54,952,429.7 μs	3,531,377.70 μs	64,425,475.40 μs	1464666.6667	441666.6667	16166.6667	9052673.76 KB
'OpenXmlSDK QueryFirst'	56,977,880.4 μs	1,631,904.33 μs	29,772,010.07 μs	893666.6667	318666.6667	14333.3333	5398491.48 KB
'OpenXmlSDK Query'	59,634,407.4 μs	1,122,034.55 μs	20,470,087.15 μs	895166.6667	318666.6667	12833.3333	5414877.95 KB
'ClosedXml Create Xlsx'	101,538,292.5 μs	5,828,011.06 μs	106,324,617.40 μs	2966166.6667	1111500.0000	12000.0000	19835972.8 KB
'ClosedXml.Report Template Generate'	174,001,921.7 μs	2,597,796.60 μs	47,393,480.76 μs	5881000.0000	1573666.6667	8666.6667	37666923.8 KB
'ClosedXml Query'	190,234,083.2 μs	1,109,981.56 μs	20,250,195.79 μs	1543666.6667	466666.6667	23333.3333	9104238.32 KB