[Libreoffice-bugs] [Bug 138644] large spreadsheet severe performance bug while creating pivot table - changing data field function is very slow

[bugzilla-daemon at bugs.documentfoundation.org]

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

s5t1e3v4e3m11 at hotmail.com <s5t1e3v4e3m11 at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |s5t1e3v4e3m11 at hotmail.com

--- Comment #12 from s5t1e3v4e3m11 at hotmail.com <s5t1e3v4e3m11 at hotmail.com> ---
Valuable observations by the OP. 

Using the 3rd attachment of the OP (attachment 168059) my 5 year old Windows i5
laptop took about 4 sec. when I changed from sum to count (Version: 7.1.2.2
(x64) / LibreOffice Community).

But when in the Pivot Table Layout under "Row Fields" I double click the
"serial"
and then in THAT dialog "Data Field" (the dialog has the same name as the OP
mentioned, which brought me here - please let me know if I should file a
different bug report) click "Options..." it took about 18 MINUTES until the
"data Field Options" dialog appeared.

The OP mentioned using many unique values; indeed this is the key to the poor
performance. Creating 1,000,000 (1 million!) rows with just 10 distinct
integers gets everything done almost instantly.

-- 
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/20210503/d3c49316/attachment.htm>