ClosedXML / ClosedXML/ClosedXML.Report

Performance issue with double grouping

Open
#277 3 comments 0 reactions 0 assignees View on GitHub
awaiting-feedback
Dominant language
C#
Stars
647
Forks
122
PR merge metrics
No merged PRs in 30d

Description

Hi
I ran into a performance issue with double grouping. On tab1, tab2 and tab3 contain about 5000 lines
tab1 and tab3 are created using ClosedXml.Report, tab2 is created using ClosedXml, the script itself runs (used Stopwatch in the script) in 7 seconds, and do not affects performance. I checked without double grouping, with one, it works for about 2 seconds, with double grouping it is generated in 4 minutes.
[Double drouping.zip](https://github.com/ClosedXML/ClosedXML.Report/files/9054940/Double.drouping.zip)

![image](https://user-images.githubusercontent.com/25920537/177526500-fba27c87-7ea7-428d-a7a4-1c257edf17c4.png)
![177525646-5e215251-c24f-4d45-8d26-c755a85804d5](https://user-images.githubusercontent.com/25920537/177526733-b4392624-06dc-4964-b5ec-29ce614dbc4a.png)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.