Description: File-opening is slower as it used to be in LibO4.4.6.3 Steps to Reproduce: 1. Open attached file and take notice of the time needed until opened Actual Results: File opening takes around 30 seconds Expected Results: Should be around 16 seconds Reproducible: Always User Profile Reset: No Additional Info: Found in (33 seconds) Version: 5.5.0.0.alpha0+ Build ID: ec79f3453471ee9b6ae32e71ff16ea99d9b7751c CPU threads: 4; OS: Windows 6.19; UI render: default; TinderBox: Win-x86@42, Branch:master, Time: 2017-05-28_23:21:44 Locale: nl-NL (nl_NL); Calc: CL and in Version: 5.2.5.0.0+ (40 seconds) Build ID: a4d4fbeb623013f6377b30711ceedb38ea4b49f8 CPU Threads: 4; OS Version: Windows 6.2; UI Render: GL; TinderBox: Win-x86@62-merge-TDF, Branch:libreoffice-5-2, Time: 2016-12-24_14:43:55 Locale: nl-NL (nl_NL); Calc: CL but not in (16 seconds) Versie: 4.4.6.3 Build ID: e8938fd3328e95dcf59dd64e7facd2c7d67c704d Locale: nl_NL User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0
Created attachment 133788 [details] Example file
Confirmed in Version: 5.5.0.0.alpha0+ Build ID: 9956849c2ea6049582e2ccf04c355542c1ef00a1 CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group time real 1m6.849s user 1m10.896s sys 0m1.140s Version: 4.3.0.0.alpha1+ Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e time real 0m20.337s user 0m19.740s sys 0m0.176s
Reproduced in - Version: 5.2.0.0.alpha1+ Build ID: 5b168b3fa568e48e795234dc5fa454bf24c9805e CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; Locale: ca-ES (ca_ES.UTF-8) real 1m13.821s user 0m57.120s sys 0m0.360s but not in - Version: 5.0.0.0.alpha1+ Build ID: 0db96caf0fcce09b87621c11b584a6d81cc7df86 Locale: ca-ES (ca_ES.UTF-8) real 0m20.029s user 0m19.648s sys 0m0.184s
I think the issue with the file, comes from the direct format on the whole sheet cells.
Callgrind output: attachment 133934 [details]
Created attachment 136853 [details] Bibisect log Slowness started with this commit. author Dennis Francis <dennisfrancis.in@gmail.com> 2016-02-05 21:42:20 (GMT) committer Markus Mohrhard <markus.mohrhard@googlemail.com> 2016-02-10 23:08:04 (GMT) commit bc20c6d0f397c0c1aef6ef7d6f750c2f81af8db6 (patch) tree 72d84f3356709b4e4413bf28e40f83b3565a2608 parent 7f02815bf90f4dee5c76f2bdb4fd84f03e27527e (diff) Refactor ScMarkData for tdf#50916 Made the container for storing multimarks dynamic. Also let the full row marks to be stored in a dedicated ScMarkArray object rather than in the multimarks container. Unit tests for ScMarkData and ScMultiSel will come in a follow up patch.
Adding Cc: to Dennis Francis Could you possibly take a look at this one? Thanks
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
still repro, in Version: 6.2.0.0.alpha0+ Build ID: 89a60912bba7ffd6f65ea99f4664f343c5025c95 CPU threads: 4; OS: Windows 6.1; UI render: default; TinderBox: Win-x86@42, Branch:master, Time: 2018-10-01_01:47:23 Locale: ru-RU (ru_RU); Calc: threaded it takes 55 sec
Dear Telesto, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Created attachment 161662 [details] perf flamegraph from Julien Nabet
*** Bug 108285 has been marked as a duplicate of this bug. ***
it takes real 0m59,856s user 1m16,512s sys 0m4,896s in Version: 7.1.0.0.alpha0+ Build ID: 8aee8c0cf1bdda1866594e75b0f9bd4b9a69c724 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
(In reply to Xisco Faulí from comment #11) > Created attachment 161662 [details] > perf flamegraph from Julien Nabet @Noel, @Luboš, I thought you might be interested in this issue...
On current master, there is nothing obvious that can be improved without a very large amount of effort. Specifically, we could import stuff without using UNO e.g. in SCXMLTableRowContext and talk directly to the main calc internal interfaces. But that is a lot of work with a high likelihood of regressions.
ohoho, only 9 sec in Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: 931e264590100c555580c413556e229a0f03316a CPU threads: 4; OS: Mac OS X 10.16; UI render: default; VCL: osx Locale: ru-RU (ru_RU.UTF-8); UI: en-US Calc: threaded Someone else, please retest it on your machines.
(In reply to Xisco Faulí from comment #13) > it takes > > real 0m59,856s > user 1m16,512s > sys 0m4,896s > > in > > Version: 7.1.0.0.alpha0+ > Build ID: 8aee8c0cf1bdda1866594e75b0f9bd4b9a69c724 > CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3 > Locale: en-US (en_US.UTF-8); UI: en-US > Calc: threaded it takes real 0m15,889s user 0m20,248s sys 0m1,403s in Version: 7.0.7.0.0+ Build ID: 6ac038c54121ec307ed75f8fb45f591cca9f8519 CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded and in Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: dff586735b6618d9b011823594a33287d8f7f223 CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Closing as RESOLVED WORKSFORME