Description: Hi, since I don't work now with such calc files regularly as I did years ago, only recently I noticed a possible regression of the Bug 54638. You can simply test the same sample attachment from that (Bug 54638). Even if I reset the LO profile (remove the whole profile "~/.config/libreoffice/4/") and start from scratch, create the same content into a new ODF v1.2 extended (default) save file (which for an instance will have about 451KiB when saved), makes no difference, still takes very long. Load: Opening it on the more powerful (PC 1) takes about 16 seconds. Opening it on the less powerful (PC 2) takes about 9 seconds. Save: Saving it on the more powerful (PC 1) takes about 5-6 minutes! Saving it on the less powerful (PC 2) takes about 8-9 minutes! While the duration of load in seconds is still tolerable, the SAVE in minutes isn't. In both SAVE cases, only one CPU core is 100% utilized during all that time. Thank you for checking it. Steps to Reproduce: Load or save the sample attachment from (Bug 54638). Actual Results: Takes minutes to save the sample. Expected Results: faster saving/export behaviour Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Affected LO calc versions tested & HW+SW details: (PC 1) CPU: Intel(R) Core(TM) i7-6700 CPU @ 3.40GHz (On-line CPU(s) list: 0-7) RAM: 16GB OS: Arch Linux kernel: Linux 4.19.41-1-lts #1 SMP Wed May 8 15:58:57 CEST 2019 x86_64 GNU/Linux LO Help\About: { Version: 6.2.3.2 Build ID: 6.2.3-2 CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: x11; Locale: sk-SK (en_GB.UTF-8); UI-Language: en-US Calc: threaded } (PC 2) CPU: Intel(R) Pentium(R) CPU G3430 @ 3.30GHz (On-line CPU(s) list: 0,1) RAM: 4GB OS: Debian GNU/Linux 9.9 (stretch) kernel: Linux 4.9.0-9-amd64 #1 SMP Debian 4.9.168-1 (2019-04-12) x86_64 GNU/Linux LO Help\About: { Version: 5.2.7.2 Build ID: 1:5.2.7-1+deb9u7 CPU Threads: 2; OS Version: Linux 4.9; UI Render: default; VCL: gtk2; Locale: sk-SK (en_GB.UTF-8); Calc: group }
repro in Version: 6.3.0.0.alpha0+ (x64) Build ID: 4cd4063f9cf531d1e948f27fcfd2eaed3d4a1a2d CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-05-08_23:08:36 Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded open - 35 sec save - I waited over 40 min and just close LO
Noel, may be you'll can look at this?
Created attachment 151324 [details] test file
With current master, loading takes approx 20s, and saving takes approx 10s
(In reply to Noel Grandin from comment #4) > With current master, loading takes approx 20s, and saving takes approx 10s It takes over 40 sec for opening and when I try to save I got over 15 min of freezing , then I killed LO Version: 6.3.0.0.alpha0+ Build ID: 773ac3abbf8ab1343367e51b1774d2ee1f8c4f49 CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded build from today (13.05.2019)
It is vaguely possible that my recent commit https://cgit.freedesktop.org/libreoffice/core/commit/?id=349919440b1454eda2de783a0c3e6bd3bae4542b makes a difference, since I tested in a tree with that commit. Otherwise, I can't help you, sorry.
(In reply to Noel Grandin from comment #6) > It is vaguely possible that my recent commit > > > https://cgit.freedesktop.org/libreoffice/core/commit/ > ?id=349919440b1454eda2de783a0c3e6bd3bae4542b > > makes a difference, since I tested in a tree with that commit. > > Otherwise, I can't help you, sorry. No, I don't see any changings in Version: 6.3.0.0.alpha1+ Build ID: f665456cd0da35649bef179755be66c2aab290a7 CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-05-16_02:11:30 Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded it's a pity...
This is perhaps now a windows- or locale- specific issue. Perhaps Roman can generate a flame graph of the bug on his machine? https://randomascii.wordpress.com/2016/09/05/etw-flame-graphs-made-easy/
Or use the Sleepy profiler https://github.com/VerySleepy/verysleepy
(In reply to Noel Grandin from comment #8) > This is perhaps now a windows- or locale- specific issue. Perhaps Roman can > generate a flame graph of the bug on his machine? > > https://randomascii.wordpress.com/2016/09/05/etw-flame-graphs-made-easy/ Telesto has mastered the Windows flame graph process
(In reply to Buovjaga from comment #10) > (In reply to Noel Grandin from comment #8) > > This is perhaps now a windows- or locale- specific issue. Perhaps Roman can > > generate a flame graph of the bug on his machine? > > > > https://randomascii.wordpress.com/2016/09/05/etw-flame-graphs-made-easy/ > > Telesto has mastered the Windows flame graph process Mastered, is a slightly overstatement.. :-). Anyway, will post a flamegraph asap. Need to update my symbols only-build first.
No repro with Version: 6.3.0.0.alpha0+ Build ID: 817e3447053d1a7465a5cf547b4eb39fc46b4d59 CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; Locale: nl-NL (nl_NL); UI-Language: en-US Calc: threaded Did something change the last 5 days?
Gyus, have just tested it with the 6.3.0 in my Linux, and the Save is working fast now, takes only seconds to save, not minutes anymore. Could you please test it again, whether it's fixed for you too?
(In reply to Roman Kuznetsov from comment #3) > Created attachment 151324 [details] > test file Saving on Win 10 takes about 4 minutes. Saving on Linux takes 45 seconds. Let's clarify summary and OS, then. Version: 6.4.0.0.alpha0+ (x64) Build ID: 3e64065612acec2eb29aa21e2b515953422256d7 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; TinderBox: Win-x86_64@62-TDF, Branch:master, Time: 2019-08-15_22:57:26 Locale: fi-FI (fi_FI); UI-Language: en-US Calc: threaded
Just for the record, the import time double after https://cgit.freedesktop.org/libreoffice/core/commit/?id=1e55a47e89a9d9d6cf9cb3993484022aaf2c097b
Saving takes 1min 14sec for me Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 9c930c4f3109d123c0831d0fcecf9c8b32e5bbc7 CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: default; VCL: win Locale: fi-FI (fi_FI); UI: en-US Calc: threaded
Testing on Windows10 with current master. Load takes 22s for me Save takes 14s. I'm sorry, I can't repro this issue - possibly it has to do with language or spelling packs ?
Dear 8472, 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 https://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://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still repro in 7.6.alpha on Windows. It takes about 30 sec. to load. It takes more than a minute to save, "no responsive" meanwhile. The file is saved with an additional 31KB, from 330KB originally to 351KB.
Confirm (In reply to ady from comment #19) > Still repro in 7.6.alpha on Windows. It takes about 30 sec. to load. It > takes more than a minute to save, "no responsive" meanwhile. The file is > saved with an additional 31KB, from 330KB originally to 351KB. Same here Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: c4a58634753a84b09f20f7271d6525a6656522d3 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: nl-NL (nl_NL); UI: en-US Calc: CL threaded
62 seconds: 7.6.0.0 ---- >120 seconds Version: 5.4.0.3 Build ID: 7556cbc6811c9d992f4064ab9287069087d7f62c CPU threads: 4; OS: Windows 6.2; UI render: default; Locale: nl-NL (nl_NL); Calc: CL and with Version: 5.2.5.0.0+ 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 and with Versie: 5.1.6.2 Build ID: 07ac168c60a517dba0f0d7bc7540f5afa45f0909 CPU Threads: 4; Versie besturingssysteem:Windows 6.2; UI Render: GL; Locale: nl-NL (nl_NL); Calc: CL --- 12 second with Versie: 5.0.6.3 (x64) Build ID: 490fc03b25318460cfc54456516ea2519c11d1aa Locale: nl-NL (nl_NL) and with 4.4.7.2
Telesto: a bibisect would be great as many have trouble reproducing this.
I was not able to reproduce on: Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded For me, it took: - 12 secs = Load - 10 secs = Save This was on Windows 11.
Takes 50 secs to save, so seems to have improved somewhat from my comment 16. Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: e939685f9c6918830bd3097062790bfccbce937e CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded