Tags: ExcelDataReader/ExcelDataReader
Tags
Reduce allocation when Reading xls files by using ArrayPool for netst… …andard 2.1 and net 8.0 targets. Before: | Method | Mean | Error | StdDev | Gen0 | Gen1 | Gen2 | Allocated | |------------------- |---------:|---------:|---------:|----------:|----------:|---------:|----------:| | ReadSingleFileXslx | 76.74 ms | 0.964 ms | 0.902 ms | 3500.0000 | - | - | 37.88 MB | | ReadSingleFileXslb | 16.71 ms | 0.160 ms | 0.149 ms | 2031.2500 | 93.7500 | - | 20.37 MB | | ReadSingleFileXls | 18.54 ms | 0.268 ms | 0.251 ms | 4187.5000 | 1312.5000 | 906.2500 | 42.74 MB | | Method | Mean | Error | StdDev | Gen0 | Gen1 | Gen2 | Allocated | |------------------- |----------:|----------:|----------:|----------:|---------:|---------:|----------:| | OpenSingleFileXslx | 35.689 ms | 0.3813 ms | 0.3566 ms | 1500.0000 | 71.4286 | - | 15.38 MB | | OpenSingleFileXslb | 6.197 ms | 0.0668 ms | 0.0592 ms | 656.2500 | 31.2500 | - | 6.56 MB | | OpenSingleFileXls | 7.859 ms | 0.0444 ms | 0.0370 ms | 1312.5000 | 437.5000 | 218.7500 | 13.49 MB | After: | Method | Mean | Error | StdDev | Median | Gen0 | Gen1 | Gen2 | Allocated | |------------------- |---------:|---------:|----------:|---------:|----------:|---------:|---------:|----------:| | ReadSingleFileXslx | 65.42 ms | 5.479 ms | 16.156 ms | 55.16 ms | 2700.0000 | 200.0000 | - | 27.13 MB | | ReadSingleFileXslb | 13.41 ms | 0.034 ms | 0.032 ms | 13.41 ms | 1484.3750 | 62.5000 | - | 14.95 MB | | ReadSingleFileXls | 16.91 ms | 0.068 ms | 0.063 ms | 16.90 ms | 2750.0000 | 968.7500 | 656.2500 | 28.32 MB | | Method | Mean | Error | StdDev | Gen0 | Gen1 | Gen2 | Allocated | |------------------- |----------:|----------:|----------:|---------:|---------:|---------:|----------:| | OpenSingleFileXslx | 20.001 ms | 0.3678 ms | 0.3440 ms | 750.0000 | 62.5000 | - | 7.75 MB | | OpenSingleFileXslb | 4.860 ms | 0.0154 ms | 0.0137 ms | 421.8750 | 23.4375 | - | 4.27 MB | | OpenSingleFileXls | 6.282 ms | 0.0290 ms | 0.0271 ms | 656.2500 | 328.1250 | 218.7500 | 5.91 MB |
PreviousNext