[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Commit Notification changed: What|Removed |Added Whiteboard|target:7.3.0 inReleaseNotes |target:7.3.0 inReleaseNotes |target:7.5.0 target:7.3.6 |target:7.5.0 target:7.3.6 ||target:7.4.1 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #35 from Commit Notification --- Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/938c899831bd5b165b2b7db3945867a1ce155483 tdf#150452: Revert "tdf#130795 use concurrent hashmap in SharedStringPool" It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://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] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #37 from Commit Notification --- Xisco Fauli committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/3d415a3d1ccd89d29a58a52a1d569f6ccff28416 tdf#150452: Revert "tdf#130795 use concurrent hashmap in SharedStringPool" It will be available in 7.4.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://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] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #36 from Commit Notification --- Xisco Fauli committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/dbfa68a56f087f06ac325a442c6cb0e99f3ecd53 tdf#150452: Revert "tdf#130795 use concurrent hashmap in SharedStringPool" It will be available in 7.3.6. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://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] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Commit Notification changed: What|Removed |Added Whiteboard|target:7.3.0 inReleaseNotes |target:7.3.0 inReleaseNotes |target:7.5.0|target:7.5.0 target:7.3.6 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Commit Notification changed: What|Removed |Added Whiteboard|target:7.3.0 inReleaseNotes |target:7.3.0 inReleaseNotes ||target:7.5.0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Xisco Faulí changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||0452 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 stragu changed: What|Removed |Added Whiteboard|target:7.3.0|target:7.3.0 inReleaseNotes Status|RESOLVED|VERIFIED --- Comment #34 from stragu --- Yes, pretty snappy now, verified as fixed in: Version: 7.3.0.2 / LibreOffice Community Build ID: f1c9017ac60ecca268da7b1cf147b10e244b9b21 CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Xisco Faulí changed: What|Removed |Added Resolution|WORKSFORME |FIXED --- Comment #33 from Xisco Faulí --- (In reply to Elmar from comment #32) > It now takes a second or two Let's close it as RESOLVED FIXED instead. Another comparison: in Version: 7.2.3.0.0+ / LibreOffice Community Build ID: f5e4dbfccdbc0d810cf82c52f14801dddf95631a CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded it takes real0m24,275s user0m32,842s sys 0m8,268s while in Version: 7.3.0.0.alpha1+ / LibreOffice Community Build ID: a14b783bbe8eda32b4b79530d85ffc48b6ed0305 CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded it takes real0m12,091s user0m15,518s sys 0m0,813s -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Elmar changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WORKSFORME --- Comment #32 from Elmar --- It now takes a second or two -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Xisco Faulí changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||9444 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #31 from Xisco Faulí --- (In reply to Luboš Luňák from comment #30) > Changes for bug #139444 now avoid use of SharedStringPool::intern() here > altogether, and it's reasonably fast. > > I don't know if we still need libcuckoo after this, keeping this open in > case Noel wants to examine that. Hi Lubos, I gave a try at it and these are my findings: 1. Import time WITH Noel's patch and WITHOUT Lubos' patches: real0m20,625s user0m26,714s sys 0m1,415s 2. Import time WITHOUT Noel's patch and WITHOUT Lubos' patches: real0m27,653s user0m32,110s sys 0m8,507s 3. Import time WITHOUT Noel's patch and WITH Lubos' patches: real0m12,181s user0m15,275s sys 0m0,774s 4. Import time WITH Noel's patch and WITH Lubos' patches: real0m11,795s user0m14,853s sys 0m0,861s -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #30 from Luboš Luňák --- Changes for bug #139444 now avoid use of SharedStringPool::intern() here altogether, and it's reasonably fast. I don't know if we still need libcuckoo after this, keeping this open in case Noel wants to examine that. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #29 from Julien Nabet --- Created attachment 175094 --> https://bugs.documentfoundation.org/attachment.cgi?id=175094=edit perf flamegraph Thank you Noel for the patches! For those interested, here's a brand new Flamegraph retrieved on pc Debian x86-64 with master sources updated today (d0940e0cca552f65ea4e85d9895682afab230c87) + enable-symbols (not enable-dbgutil) + brand new LO profile + gen rendering. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Julien Nabet changed: What|Removed |Added Attachment #174931|0 |1 is obsolete|| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Julien Nabet changed: What|Removed |Added Attachment #158062|0 |1 is obsolete|| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #28 from Noel Grandin --- After doing several rounds of optimisation to the uppercase machinery, I can get it to be __almost__ as fast as using the SharedStringPool :-) Possibly there is some stuff that could be done with the tables in i18nutil/ but I don't feel like touching that -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #27 from Luboš Luňák --- That said, looking at the profiling of the comment #25 code, the majority of time spent there is not spent actually uppercasing the string, it's spent in lock contention and the i18n classes repeatedly updating their internal state. Without that, it seems the performance would be about the same. So the reason why the SharedStringPool version is faster is because our i18n code is dumb (at least as far as performance goes) and usage of libcuckoo removes these problems from SharedStringPool, not because using SharedStringPool be inherently faster here. But I don't think I'll have the time to try to redesign the i18n code or look into why ValidQuery() gets called so often. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #26 from Luboš Luňák --- No, that's the code I had in mind, I assumed that intern() would be slower than using the string directly, as was the case with bug #144249. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #25 from Noel Grandin --- (In reply to Luboš Luňák from comment #21) > The real problem here is not that SharedStringPool would be slow, but that > ScTable::ValidQuery()/QueryEvaluator calls it at all. If you look at how The primary call-site in this bug is QueryEvaluator:: compareByStringComparator which is this code: https://opengrok.libreoffice.org/xref/core/sc/source/core/data/table3.cxx?r=0a9b68c9#2687 If I switch that to // fallback const CharClass& rCharClass = *ScGlobal::getCharClassPtr(); rtl_uString* pTmpRHS = const_cast(rItem.maString.getDataIgnoreCase()); bOk = rCharClass.uppercase(*pValueSource2) == OUString::unacquired(); This document takes twice as long to load. Possibly you had something else in mind? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #24 from Luboš Luňák --- > So we could also remove the brand new lib dependency on cuckoo (unless it > could be used for something else?) I think so. > Kohei was in the trio Calc experts (Eike, Kohei, Markus), so I suppose he > had done some perf tests but perhaps with all code change after all these > years, those are no more relevant? Using SharedString is worth it if the object is used multiple times to offset the creation cost. The problem here is that the object is used just once. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Julien Nabet changed: What|Removed |Added CC||er...@redhat.com --- Comment #23 from Julien Nabet --- (In reply to Luboš Luňák from comment #21) > The real problem here is not that SharedStringPool would be slow, but that > ScTable::ValidQuery()/QueryEvaluator calls it at all. If you look at how > it's used, those strings are interned only to do a "fast" case-insensitive > comparison _once_, but interning a string apparently takes way longer than a > normal comparison would. The concurrent hashmap change is band-aid (at least > in this case), the real fix should be removing the SharedStringPool usage > from QueryEvaluator. Bug #144249 has a similar problem. So we could also remove the brand new lib dependency on cuckoo (unless it could be used for something else?) About SharedStringPool, I took a look at git history. git log --follow -S 'svl::SharedStringPool' sc/source/core/data/table3.cxx commit 2f39c27be2bd66f149e0a4efdd7fa37daee43fb1 Author: Kohei Yoshida Date: Wed Oct 9 10:50:23 2013 -0400 Use shared string's fast equality check for ValidQuery(). Change-Id: Ib84087a10cc10a7533e64c4e8998354b52017df7 commit a11e224e07a4fda0de64a9a0a181f6034e08d2e5 Author: Kohei Yoshida Date: Tue Oct 8 21:46:56 2013 -0400 Store svl::SharedString in query entry items, and adjust all call sites. Change-Id: Ifd3bbb84c7abbe983a017a169c7e05914ef33450 Kohei was in the trio Calc experts (Eike, Kohei, Markus), so I suppose he had done some perf tests but perhaps with all code change after all these years, those are no more relevant? Eike: any thoughts here? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #22 from Luboš Luňák --- (The relevant commit for bug #144249 being https://git.libreoffice.org/core/commit/d0316985db22efd6708dffa173eaabb430f6b9a8, I did not CC the bugreport on that one. And I don't know if I'll have the time to do the suggested change and test it, so feel free to.) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Luboš Luňák changed: What|Removed |Added CC||l.lu...@collabora.com --- Comment #21 from Luboš Luňák --- The real problem here is not that SharedStringPool would be slow, but that ScTable::ValidQuery()/QueryEvaluator calls it at all. If you look at how it's used, those strings are interned only to do a "fast" case-insensitive comparison _once_, but interning a string apparently takes way longer than a normal comparison would. The concurrent hashmap change is band-aid (at least in this case), the real fix should be removing the SharedStringPool usage from QueryEvaluator. Bug #144249 has a similar problem. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #20 from Xisco Faulí --- it takes real0m17,823s user0m26,524s sys 0m1,320s with the commit from comment 18, while it takes real0m28,101s user0m38,720s sys 0m7,812s without it. Nice improvement -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #19 from Julien Nabet --- Created attachment 174931 --> https://bugs.documentfoundation.org/attachment.cgi?id=174931=edit perf flamegraph Here's the Flamegraph retrieved on pc Debian x86-64 with master sources updated today (8104d771b10a5c8b15eae4b67aa112ae2ef77b5b). I just put the trace for info. If something can be optimized, great, if not, not a pb since it's quite quick to open. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #18 from Commit Notification --- Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/3749d9af3745c0eaff7239e379578e4e2af89e9d tdf#130795 use concurrent hashmap in SharedStringPool It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://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] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #17 from Noel Grandin --- (In reply to Timur from comment #16) > On fileopen we see "Adapt row height" so it indicates where time is spent. Not in this case, profiler says time is now all over the place. https://gerrit.libreoffice.org/c/core/+/121717 will improve it considerably when it lands -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #16 from Timur --- Linux 7.3+, same system: Pre fix 1st time: real0m36,454s user0m58,049s sys 0m3,584s Pre fix 2st time: real0m33,827s user0m52,990s sys 0m2,951s Post-fix 41a46a306f40a7296c56bdeea0ba8a6d630aa15c 1st time: real0m35,072s user0m55,159s sys 0m3,097s Post-fix 2st time: real0m29,631s user0m45,245s sys 0m2,412s So fix improved this slightly. On fileopen we see "Adapt row height" so it indicates where time is spent. 73+ 1st time: real0m35,328s user0m55,636s sys 0m3,704s 2nd time: real0m35,395s user0m56,583s sys 0m2,735s Those timings are not exact. Real time of 30-35 sec could be considered as good as it ever was (but not as it should be). User time of 45-55 sec is longer than 20 sec in 6.2. User+Sys should be CPU time, so indicating worse perf. Here on a multicore system, the user and sys time exceed the real time. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #15 from Commit Notification --- Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/41a46a306f40a7296c56bdeea0ba8a6d630aa15c dynamic_cast -> static_cast (tdf#130795) It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://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] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Commit Notification changed: What|Removed |Added Whiteboard||target:7.3.0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Timur changed: What|Removed |Added Version|4.4 all versions|6.2.0.3 release -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Timur changed: What|Removed |Added Keywords||regression -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Timur changed: What|Removed |Added OS|Linux (All) |All -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Timur changed: What|Removed |Added Blocks||125077 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=125077 [Bug 125077] [META] regressions introduced by row height recalculation on document load -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #14 from Timur --- Linux 5.2 m: real0m31,827s user0m18,338s sys 0m0,799s Linux 6.0 m: real0m39,547s user0m21,360s sys 0m1,238s Linux 6.2 pre 1e55a47e89a9d9d6cf9cb3993484022aaf2c097b (time spent on loading, calculating): real0m40,949s user0m22,269s sys 0m1,295s Linux 6.2 with 1e55a47e89a9d9d6cf9cb3993484022aaf2c097b: real1m46,854s user1m28,051s sys 0m1,488s Linux 6.3 m: real1m20,008s user1m49,742s sys 0m3,880s Linux 7.0 m - initially reported version: real1m38,572s user2m7,639s sys 0m4,439s Linux 7.3+ master real0m56,994s user1m27,686s sys 0m5,903s Time recorded on 2nd load so it's longer in reality. In current master 7.3+ time is better than when reported with 7.0 but it's still worse than before. Can be considered a regression so I block to bug 125077. Recalculate in Tools/Options.../LibreOffice Calc/Formula is for formula and I don't see it as relevant, all test are without recalculation. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Timur changed: What|Removed |Added See Also|https://bugs.documentfounda | |tion.org/show_bug.cgi?id=13 | |0383| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Telesto changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||0383 -- 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 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Xisco Faulí changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||4098 -- 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 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Xisco Faulí changed: What|Removed |Added CC||noelgran...@gmail.com --- Comment #13 from Xisco Faulí --- (In reply to Julien Nabet from comment #12) > Created attachment 158062 [details] > Flamegraph > > Here's a Flamegraph retrieved on pc Debian x86-64 with master sources > updated today. Thanks a lot! @Noel, I thought you might be interested in this performance issue -- 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 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #12 from Julien Nabet --- Created attachment 158062 --> https://bugs.documentfoundation.org/attachment.cgi?id=158062=edit Flamegraph Here's a Flamegraph retrieved on pc Debian x86-64 with master sources updated today. -- 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 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Xisco Faulí changed: What|Removed |Added Version|6.1 all versions|4.4 all versions --- Comment #11 from Xisco Faulí --- (In reply to Xisco Faulí from comment #9) > ok, it takes > > real 0m58,031s > user 0m41,518s > sys 0m2,249s > > in it takes real8m20,334s user7m57,766s sys 0m3,060s with the same version if recalculation is enabled -- 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 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Xisco Faulí changed: What|Removed |Added Keywords|bibisectRequest, regression |bibisected, bisected --- Comment #10 from Xisco Faulí --- so, the import time got worse after https://cgit.freedesktop.org/libreoffice/core/commit/?id=1e55a47e89a9d9d6cf9cb3993484022aaf2c097b, however, it doesn't mean the problem was introduced by this commit. In previous versions, ie 6.0. the issue can be reproduced if recalculation on File Load for ODF files is set to Always Recalculate in Tools/Options.../LibreOffice Calc/Formula -- 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 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Xisco Faulí changed: What|Removed |Added Keywords||bibisectRequest, regression Version|4.4 all versions|6.1 all versions --- Comment #9 from Xisco Faulí --- ok, it takes real0m58,031s user0m41,518s sys 0m2,249s in Version: 6.0.0.0.alpha1+ Build ID: 6eeac3539ea4cac32d126c5e24141f262eb5a4d9 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); Calc: group threaded so it seems it was pretty slow in the past, improved a lot, and now it has regress a little bit -- 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 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #8 from Xisco Faulí --- (In reply to Elmar from comment #6) > How come v6.0 is so much faster? > When check edit/links, shows that the setting is "manual" - so should it not > check that and ignore the links? > v6.0 also has a progress bar - not shown in v7 > (at least one knows that that Calc has not frozen) Which version? Could you please paste the info from Help - About LibreOffice ? -- 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 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Xisco Faulí changed: What|Removed |Added Version|5.2 all versions|4.4 all versions --- Comment #7 from Xisco Faulí --- it takes real7m6,001s user6m45,494s sys 0m1,733s in Version: 4.3.0.0.alpha1+ Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e -- 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 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #6 from Elmar --- How come v6.0 is so much faster? When check edit/links, shows that the setting is "manual" - so should it not check that and ignore the links? v6.0 also has a progress bar - not shown in v7 (at least one knows that that Calc has not frozen) -- 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 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 --- Comment #5 from Julien Nabet --- (In reply to Xisco Faulí from comment #4) > @Julien, would it be possible to have a perfchart for this issue ? No pb, I'll do it after my daytime job. -- 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 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Xisco Faulí changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment #4 from Xisco Faulí --- @Julien, would it be possible to have a perfchart for this issue ? -- 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 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Xisco Faulí changed: What|Removed |Added Version|7.0.0.0.alpha0+ Master |5.2 all versions --- Comment #3 from Xisco Faulí --- in Version: 5.2.0.0.alpha0+ Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53 Threads 4; Ver: 4.19; Render: default; it takes real8m36,323s user7m32,024s sys 0m2,208s so I great improvement has been done -- 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 130795] FILEOPEN: Spreadsheet takes long to open
https://bugs.documentfoundation.org/show_bug.cgi?id=130795 Xisco Faulí changed: What|Removed |Added Keywords||perf CC||xiscofa...@libreoffice.org Ever confirmed|0 |1 Summary|Spreadsheet takes long to |FILEOPEN: Spreadsheet takes |open|long to open Status|UNCONFIRMED |NEW --- Comment #2 from Xisco Faulí --- it takes real2m22,490s user3m12,778s sys 0m32,862s in Version: 7.0.0.0.alpha0+ Build ID: bc994a4b01cf6152bb377010c7c4cc377698 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded -- 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