Created attachment 117265 [details]
ods file with many hyperlinks
A file with many hyperlinks (90000) is very slow on loading, saving and scrolling is not smooth - hangs for a while every now and then. It is a regression, it worked well for versions 220.127.116.11.beta1 to 18.104.22.168 - the slowdown is about 200 times.
Detailed statistics, LO versions downloaded from http://downloadarchive.documentfoundation.org/libreoffice/old/
"last slow",Version: 22.214.171.124, Build ID: 8a35821d8636a03b8bf4e15b48f59794652c68ba, 10 min,clumsy,10 min
"first fast",Version: 126.96.36.199.beta1, Build ID: 9af3d21234aa89dac653c0bd76648188cdeb683e,4 s,smooth,3 s
"last fast",Version: 188.8.131.52, Build ID: b5ac74bf8683a92078a2bc8aff97d4b436af63cb, 4 s,smooth,3 s
"fist slow",Version: 184.108.40.206, Build ID: 45e2de17089c24a1fa810c8f975a7171ba4cd432, 10 min, clumsy, 10 min
I would also bibisect it, but I was not able to find the right git repository to clone. This information is missing in e.g. in https://wiki.documentfoundation.org/QA/Bibisect
I can confirm with Version: 220.127.116.11.alpha1+
Build ID: 9be553f4c61f220ebbe212dc76cb9cce4ae1c106
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-07-13_22:45:19
works OK with Version: 18.104.22.168.alpha2+
Build ID: 3f94c9e9ddfd807b449f3bb9b232cf2041fa12d2
The below commit appears to be where loading this file started to be slow.
I don't see that Henry Castro has a BZ account, so no way to forward this directly
Author: Henry Castro <firstname.lastname@example.org>
AuthorDate: Tue Feb 10 18:27:13 2015 -0400
Commit: Eike Rathke <email@example.com>
CommitDate: Thu Feb 12 11:07:09 2015 +0000
fdo#82719 EDITING: String with hyperlink not pasted
Fixed. It is impossible to copy / paste a string with hyperlink what is part of a longer string in cell.
Tested-by: Jenkins <firstname.lastname@example.org>
Reviewed-by: Eike Rathke <email@example.com>
Tested-by: Eike Rathke <firstname.lastname@example.org>
I confim that reverting the commit 5a646f04cc40fb13f39b16ab452237e5cf324684
on master do put the performance back in 'normal'
and 'slow' does not just describe it.. without the revert I
have a document(sent to the ML by milos sramek) that I basically killed after 5+ minutes cpu trying to load it.
with the revert it load in few seconds...
Migrating Whiteboard tags to Keywords: (bibisected)
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":
don't pool SvxFieldItem, tdf#92773
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:
Affected users are encouraged to test the fix and report feedback.