Performance issue with double grouping

[enverkrinickii]

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

[enverkrinickii]

UPD: in first screenshoot generation was between: 10:01:51 and generated in 10:03:23 in the second: 7:39:22 and 7:47:01

[Pankraty]

Please, check if performance got better with the latest develop branch: in recent versions on ClosedXML there were significant improvents, this might have helped.

[dakidd88]

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

Delete