Description: In 2019, I created a thread about a file that took a long time to open and save (https://bugs.documentfoundation.org/show_bug.cgi?id=125665). Improvements were made and the thread was closed, but a few days ago, out of curiosity, I checked to see how long it took for the file to open and save on my new, much faster laptop. I created the original document by opening a text file in LO 6.2.4 and then saving it as an ODT file. My initial tests were done on a first-generation Intel Core i7 with 8 GB of DDR 3 RAM running Windows 10 1903, 18362.145. 1. These were my results on LO 6.2.4 (before the patches): - Time to open the file: 3m51s. - Time to save the file (after replacing one character): 3m03s. 2. There were my results on LO 6.3.0 beta 1 (after the patches): - Time to open the file: 2m25s. - Time to save the file (after replacing a character): 2m10s. As shown, significant improvements were made. In 2021, I switched to an AMD Ryzen 4800H with 16 GB of DDR4 RAM, and so, I was expecting big additional improvements. 3. These are my results on Windows 11 23H2 (22631.3296) and LO 24.2.1.2: - Time to open the file: 5m49. - Time to save the file (after replacing a character): 0m14s. As shown, the document has taken almost three and a half more minutes to open. However, saving the file was much faster. In case the problem had to do with the fact that I created the document on an old LibreOffice version, I decided to create it again on LO 24.2.1.2 from the same text file. These were my results, which were mostly the same as before: - Time to open the file: 5m48. - Time to save the file (after replacing a character): 0m15s. In my tests, before opening the document, there is a progress bar for about 5 seconds, and then the programme gets stuck for the rest of the time. Steps to Reproduce: See above. Actual Results: See above. Expected Results: See above. Reproducible: Always User Profile Reset: No Additional Info: Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded
Created attachment 193084 [details] Documents The ZIP file contains: 1. The original text file. 2. The document created in LO 6.2.4 3. The document created in LO 24.2.1.2.
Just as a reference, I decided to create a DOCX document based on the same text file. I used OnlyOffice 8.0.1. I did the same kind of tests and these are the results: - Time to open the file: 0m11s. - Time to save the file (after replacing a character): 0m11s. I also did a test on OnlyOffice opening and saving the original LibreOffice document created on LO 6.2.4. These are the results: - Time to open the file: 0m11. - Time to save the file (after replacing a character): 0m15s.
Created attachment 193097 [details] DOCX document created on OnlyOffice
I wanted to add something to my previous messages, but please let me know if I should open a different report. I've just realized that if I'm working on a particular document (in my case, a Calc document) and then I open my big Writer document, the whole programme becomes unresponsive and I can't do anything on my Calc document while the Writer document is in the process of getting open, which, in my case, means waiting for more than 5 minutes. Would there be a way to make these two processes independent from each other, so that you can work on a document while a process is getting another document busy?
Whatever the problem was here seems to have been fixed in the meantime - opening this on current master (i.e. version 24.8) it takes less than 5 seconds on my fairly fast machine.
Thanks for your comment, Noel. I've immediately tested LO 24.8.0.0.alpha 0 and, as you said, the problem seems to be fixed: - Time to open the file: 7 seconds. - Time to save the file: 15 seconds. This is great news, but I wonder if these changes could be backported to the 24.2 branch. Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 0c9f650136277b708912a86a6867ec91c8b384a5 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded
The problem also affects the 7.6 branch. These are my results on 7.6.6.2: - Time to open the file: 5m57. - Time to save the file: 16s. Version: 7.6.6.2 (X86_64) / LibreOffice Community Build ID: 036e73768e828796af6f3a43aa3296f3df77bb1d CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded
Not reproduced in any version (7.6.5, 24.2.2, 24.8alpha0+) on Ubuntu 22.04. Not reproduced either on Windows 11: Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 4; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded If it works with a development version, I'm wondering if it is linked to your user profile. Can you please back it up and test with a fresh one? https://wiki.documentfoundation.org/UserProfile
Thank you for the information! I should have reset my user's profile in the first place, but I had never done it before and I thought my issue could not be related to a corrupted profile. I had no idea that a corrupted profile could have such a big impact on performance, and to be honest, I don't have a lot of personal settings: no extensions and little customization (light mode, extralarge icons, etc.). In any case, in the future, I'll check my profile just in case. My issue seems to be fixed now: - Time to open the file: 7 seconds. - Time to save the file (after replacing a character): 16 seconds. Version: 24.2.2.2 (X86_64) / LibreOffice Community Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded
Thanks you for reporting back. Let's mark as "works for me" then.