Summary: | Very slow switching between sheets in the attached xlsx document | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Kevin Suo <suokunlong> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | buzea.bogdan, ilmari.lauhakangas, l.lunak, miguelangelrv, serval2412 |
Priority: | medium | Keywords: | perf |
Version: | 6.3.5.2 release | ||
Hardware: | All | ||
OS: | Linux (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 136524 | ||
Attachments: |
Test xlsx file
perf flamegraph (when loading the file) Flamegraph (when switching sheet) |
Description
Kevin Suo
2020-03-26 10:18:17 UTC
This issue was originally reported on the LibreOffice Chinese discussion forum: https://bbs.libreofficechina.org/forum.php?mod=redirect&tid=2421 Opening the file there is a message that it exceeds the columns number limits. And file crash LibreOffice when I try to go to the second sheet. Trying loading the document is already quite slow, more than (for a 480KB file on pc with Ryzen 2600 + 32GB) real 0m16,036s user 0m15,769s sys 0m1,313s + I got this warning: Warning loading document ...: The data could not be loaded completely because the maximum number of columns per sheet was exceeded. Created attachment 159095 [details]
perf flamegraph (when loading the file)
Here's a Flamegraph retrieved on pc Debian x86-64 with master sources updated today.
It corresponds to loading only.
I'll attach another Flamegraph about the switching part.
Created attachment 159096 [details]
Flamegraph (when switching sheet)
I must say that I use gtk3 so with all accessibility mechanism which seems to slow down things.
Tab switching is not very slow for me and memory use does not explode. Kevin: please re-test 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 (In reply to Buovjaga from comment #6) Switching to the 2nd tab is still slow for me in Version: 7.3.4.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN Ubuntu package version: 1:7.3.4-0ubuntu0.22.04.1 Calc: threaded and Version: 7.4.0.0.beta1+ / LibreOffice Community Build ID: 6ea86593851c731e2e2b969e458255e4159c80d9 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN Calc: threaded |