[Libreoffice-bugs] [Bug 144159] New: [1] Countifs() performance regression

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144159

            Bug ID: 144159
           Summary: [1] Countifs() performance regression
           Product: LibreOffice
           Version: 7.2.0.4 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: adnanbaloch at gmail.com

Description:
I have an Excel sheet with data in 187,000 rows. I use this sheet to benchmark
Calc to see if countifs() calculation speed has improved with a new version. I
calculate countifs() with two criteria and fill 10,000 rows with the results.
Previously, it would take around 350 seconds to complete. Now, even for 500
rows, the countifs() formula is not able to finish the calculation after more
than 120 seconds. 

Steps to Reproduce:
1.Create large number of random data at least in at two columns with 187,000
rows.
2.Run countifs with two criteria on the data to return result in 10,000 rows.

Actual Results:
countifs() keeps on running and does not return any result even after more than
6 minutes.

Expected Results:
It used to return the results within 350 seconds on my i7-4770. Also tried it
on a newer laptop with Core i3-115G4 CPU. Calc 7.1.5 completes the calculation
in 326 seconds on the i3. Calc 7.2.0.4 doesn't complete even after 6 minutes.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
OpenGL version 3.0 to 4.3 features are enabled.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210829/046356c3/attachment.htm>