[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 Markus Mohrhard changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |markus.mohrhard@googlemail. |desktop.org |com --- Comment #18 from Markus Mohrhard --- (In reply to Buovjaga from comment #17) > I still repro the CSV saving slowness of many minutes. > > I was unable to do a cachegrind, it killed itself before UI launched. > > Used these: > https://wiki.documentfoundation.org/QA/BugReport/Debug_Information#GNU. > 2FLinux:_How_to_get_a_cachegrind_trace > > Arch Linux 64-bit, KDE Plasma 5 > Version: 5.2.0.0.alpha0+ > Build ID: 8d267cdd48e8b736a81a9e76ea5803e6847d791e > CPU Threads: 8; OS Version: Linux 4.4; UI Render: default; > Locale: fi-FI (fi_FI.UTF-8) > Built on March 24th 2016 They do a detailed explanation what you are doing. Explain it to me like I would be an idiot. Keep in mind that I'm a developer so I might always miss something completely trivial. The first thing that comes to my mind are the csv import settings. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #17 from Buovjaga --- I still repro the CSV saving slowness of many minutes. I was unable to do a cachegrind, it killed itself before UI launched. Used these: https://wiki.documentfoundation.org/QA/BugReport/Debug_Information#GNU.2FLinux:_How_to_get_a_cachegrind_trace Arch Linux 64-bit, KDE Plasma 5 Version: 5.2.0.0.alpha0+ Build ID: 8d267cdd48e8b736a81a9e76ea5803e6847d791e CPU Threads: 8; OS Version: Linux 4.4; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Built on March 24th 2016 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 Timur changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=93 ||405 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #16 from Markus Mohrhard --- I can't reproduce the ODS problems either. At least according to callgrind there is nothing strange going on. Most of the time is spent writing xml elements and in the deflate function of the zip code. If anyone can still reproduce this in current master I need better steps to reproduce this. The pushed patch is only for CSV import. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #15 from Commit Notification --- Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7da3a53958695bfb1405fa513f71beddc6c0ecb7 don't allocate and destroy a LocaleDataItem for each cell, tdf#97989 It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 Commit Notification changed: What|Removed |Added Whiteboard||target:5.2.0 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #14 from Markus Mohrhard --- I can't reproduce the slow saving in master. With callgrind the export to csv is much faster than the import (at least until my import fix lands in master). Unless there is something that is not mentioned in the bug report I can't reproduce the problem. The slow ODS export is somewhat expected based on the ODF spec. I have not yet profiled the ODF export. Import performance fix is landing soon. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #13 from ras...@tiscali.cz --- Just tested on another machine: old Thinkpad T61, win7x32, 3GB RAM, core2duo T7300 (2Ghz) LO 5103x32 portable works without issue. LO 5052x32 portable also without issue. In Both cases loading of the file took 30 seconds, saving to CSV 10 seconds and saving to ODS 30 seconds. Acceptable times for such old machine and much bether then my new laptop with i7 cpu due to the bug. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 Beluga changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||todven...@suomi24.fi Ever confirmed|0 |1 Severity|normal |major --- Comment #12 from Beluga --- Repro. Saving to CSV took about 5 minutes. Win 7 Pro 64-bit Version: 5.2.0.0.alpha0+ Build ID: ef02de2698d90fd874bddf3146165cbe85487bc5 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2016-02-19_23:40:50 Locale: fi-FI (fi_FI) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #11 from ras...@tiscali.cz --- Just tried LO 5111x64 (uninstalled previous, removed profiles, installed new, reboot) and still same behavior :/ Saving to ODS 7 minutes, to CSV also around that. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #9 from MM --- Notice that if this is the same issue as in bug 93405 the ods saving still isn't fixed yet. What strange is, is that on multple machines the saving is so much slower than mine (under vbox). -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #10 from ras...@tiscali.cz --- Exactly. What I also don't understand is following: I tried version 5103x32 portable from portableapps.com on my laptop (the first tested machine) it performs OK - saving is only about 20 seconds. On the third machine however (win7 i5 desktop) it takes 90 secodns - so to me it looks like the same build is working differently on different machines :/ -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 ras...@tiscali.cz changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #8 from ras...@tiscali.cz --- I still have the issue uninstalled, removed profile and re-installed LO 5103x64 on second (old desktop) and third (new desktop) and the issue is still there. Also tried to disable antivirus (MSE) without any effect. On the laptop I use COMODO CIS. Language versions used: Laptop - english windows, english LO desktops - czech windows, czech LO Portable versions were english. I need to check again the portable versions as in one of the tests the issue did not happen, in others it did happen. :/ -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #7 from ras...@tiscali.cz --- Just tested on different machines. Win7 Desktop, older - with AMD Athlon X2 240 cpu, 4GB RAM 5.0.4.1 x64 - same issue - CSV 8 minutes, ODS 10 minutes, forgot to test XLSX 5.1.0.3 x32 - same issue (though bit faster) - CSV 5 minutes, ODS 6 minutes, XLSX about 30 seconds only 5.0.2.2 x64 - same issue - CSV 8 minutes, ODS 10 minutes, XLSX about 30 seconds only 5.1.0.3 x64 - same issue - CSV 8 minutes, ODS 10 minutes, XLSX about 30 seconds only All version tested were installed versions, no portables third machine - desktop win7x64, cpu intel i5-3470 quad core, 12 GB RAM 5.0.3.2 x64 - same issue - saving to CSV 3 min, saving to ODS 3 min, to XLSX 15 seconds 5.1.0.3 x32 portable - same issue but faster - saving to CSV 90 seconds, to 0DS 90 seconds, to XLSX 15 seconds Will try to reinstall and reset the user profile next. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 MM changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #6 from MM --- Tested with v5.0.5.2 & v5.1.1.1 under ubuntu 14.04 x64 and 5.1.1.1 under windows 10 x64. Saving to ODS will take from about 20 - 40 secs, but not 6-7 mins. And about 10-15 secs to csv... You might wanna try resetting your user profile and report back. https://wiki.documentfoundation.org/UserProfile#Resolving_corruption_in_the_user_profile -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #5 from ras...@tiscali.cz --- Ok I understand. I though there is some bug in a saving library / module / component and filed this in 1 bug, because the behavior is similar. Also I searched for duplicates when creating this and none seem to describe similar issues, so I filed this. I will have access to more PCs over the weekend so I'll try the same on different machines and LO versions and will posts the results. If anything more specific is needed (log outputs, whatever...) I will need some guidance on this. Thank you -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #4 from MM --- (In reply to rascal from comment #3) > If you check the evidence, very slow saving is also to CSV, not only ODS. > Moreover it happens on version 5.1.0.3 x64, but not on same version x32 and > not on 4.7.7.2 x32. Well normally it's one bug in one report, not two. That ods and csv saving might be slow doesn't mean that they are related. So that's why i told you that slow ods saving might be a dup. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #3 from ras...@tiscali.cz --- Hi, If you check the evidence, very slow saving is also to CSV, not only ODS. Moreover it happens on version 5.1.0.3 x64, but not on same version x32 and not on 4.7.7.2 x32. It does not seem like a duplicate to me. If provided some guidance, I can run more tests (different versions, architectures, cleaning profile etc) thank you -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #2 from MM --- The slow saving to ods seems like a dup, bug 93405 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 ras...@tiscali.cz changed: What|Removed |Added Keywords||perf -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 97989] LO Calc very poor performance when saving to ODS or CSV on large spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=97989 --- Comment #1 from ras...@tiscali.cz --- Created attachment 122782 --> https://bugs.documentfoundation.org/attachment.cgi?id=122782&action=edit test replicated on LO 5103x32 portable and it works fine test replicated on LO 5103x32 portable and it works fine. It looks like the issues is only on x64 version. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs