[SOLVED] LibreOffice slow to open moderately large to pretty large files
UbuntuThis forum is for the discussion of Ubuntu Linux.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
LibreOffice slow to open moderately large to pretty large files
I'm running Ubuntu MATE on a System76 Lemur. (I can give more details if needed. The specs in my sig are for my Desktop, I think.) It's a fresh install as of last night (and first time I've run Ubuntu MATE), and on a new computer. LibreOffice Writer takes a very long time to load files that are even moderately large. The loading bar completes pretty quickly, but then it freezes for somewhere between 60 seconds and 3 or 4 minutes before I get control.
Based on this information, I'm guessing that the problem isn't loading the file, but drawing it on the screen. But, that's a guess.
I don't have this problem on my desktop machine (which currently runs Mint), and I didn't have this problem with a very old Dell that this laptop is replacing.
Test files that I've used are a document that's a little more than 2500 pages (that one has always taken a decent amount of time to load, but it was still less than 20 seconds on other machines), and a test file that's ~500 pages long.
I've tried:
Deleting the config folder.
Downgrading to LibreOffice 4.
Disabling "Use a Java runtime environment" in the settings.
Increasing the memory for use with the graphics cache.
Enabling systray Quickstarter.
Messing around with the Graphics Output section of the "View" settings.
Disabling antialiasing.
Most of these were based on suggestions that I found online. None made any difference.
I'm also starting to look into the "Expert Configuration," but that seems to make Writer crash altogether.
This isn't an unmanageable problem, but if anybody has any idea what could fix it, I would greatly appreciate it.
I got one match searching for "slow to load" but that was very old (3.x) series. It may be worth logging a bug but they would almost definitely expect a sample.
It is probably worth mentioning that I have a file which is slow at times. I know the problem is to do with a internet link I included but (again, not unmanageable so I haven't bothered trying to fix it).
The original file that I noticed it on (2000+ pages, 6+ mb) was originally a docx file, then I converted it to odt. I then did a simple copy-paste into a new file, same problem. Then the test file, which was just 400 pages of the word "test," was written in LO Writer from the beginning, and it had the same problem.
I'm also not entirely sure that the problem isn't in Ubuntu MATE (or the combination of Ubuntu MATE with my particular computer). It seems like it could be a video card issue, since it seems like the problem is drawing the document on the page, not loading the document. I'm not really sure how to edit video card driver settings on this new computer, but I'll do a little more of that later and report my progress. I think I'll also try enabling Compiz.
I am using Fedora 23 with LO 5.1. I used the Lorem Ipsum plugin and copy/paste to generate a 495 page document. This opened with no problems at all! I have a decent but old PC.
I notice you referenced different versions of LO. I am assuming you downloaded from the LO site and not from the Ubuntu repos? Just wondering whether either/or is better? Like is the version from the repos optimised for that distro!
Yeah, it's definitely not something that applies to all distros, and I'm guessing not all Ubuntu MATE machines or there would be more people talking about it. It didn't happen on my old Dell laptop (which was *very* old), and it doesn't happen on my Desktop (the specs for that are in my sig, not too bad).
It first happened in the LO that came installed with MATE, which was 5, and I downgraded to 4 via LO's website. I'm upgrading back to 5 right now, since that apparently wasn't the problem.
I just tried switching to Compiz-- no dice. (I do like Compiz, though.)
I'm not having much luck tweaking video settings, primarily because I just don't know how. :\ I'm used to either AMD or NVIDIA, and this is Intel. That's a different question, though-- I'll try to figure it out on my own before posting it.
Update: Abiword seems to have no problem with the 400 pg document, but it seems to struggle just as much with the 2000 pg one.
Last edited by adanedhel728; 01-13-2016 at 11:47 PM.
what are the specs for the affected machine?
how have you installed LO and what version is it? which version is in the repos?
any other tweaks to your setup? how does it go when you use the default mate session (instead of compiz)? i could well imagine LO having difficulties with compiz, esp. since compiz is not officially developed anymore iirc?
Specs for the laptop (I'll put this in my sig later): System 76 Lemur, 64-bit CPU and OS, Intel Core i3 CPU @ 2.3 GHz, quad-core. 8 gb ram. Sky Lake Integrated Graphics from Intel, 33MHz clock. Can't seem to find more information than that in lshw.
I first tried the LO that came preinstalled with Ubuntu MATE (5.0.2.2), then I uninstalled it and tried downgrading to 4 point something from the deb files on the LO website. Since I had the same problem in both, I uninstalled that and reinstalled LO 5 from Synaptic (and not a special PPA-- just from the sources that come with Ubuntu MATE).
No other tweaks to my setup that I can remember except that Dropbox is installed, and I don't use Compiz regularly-- I only enabled it to see if it could draw the document more quickly than Marco (Marco being the default), and it couldn't, so I switched back for stability purposes.
Last edited by adanedhel728; 01-14-2016 at 07:01 PM.
Reason: Corrected LibreOffice version number.
Based on my experiences in the past I would have suggested the graphics cache.
Maybe fire up latencytop and see if gives a hint. Let it run for a while so you know what "base line" number look like then fire up your document.
You might want to look at iotop as well, because it's likely a disk problem.
I'm not sure if this is related, but I did just discover something odd. First of all, my CPU is actually dual core but with four threads. I don't know what that actually means (I'm not a hardware person), but in the System Monitor, that translates into four CPUs.
And CPU4 is pretty much always running around 90, the the processes that are taking up all of that are kworker/3:0 and ksoftirqd/3 (which only show up if I run the mate-system-monitor as root).
I'm doing research on this, and if it turns out to be relevant, I'll get back. I know very, very little about how software uses multiple cores, but my guess is that if some other program is hogging up the only CPU that LO will use, that could cause the problem.
Something else might also be related-- You asked if there were any other tweaks to my system, and I remembered one that might be relevant-- I installed KATE and any KDE dependencies that are required for it to run correctly.
Those are kernel threads - you never want to see them high in CPU. Best guess would be a driver problem - and they can be very difficult to diagnose. here is a post I made a few days back that might help here too.
Might also be worth looking at /proc/interrupts 15 seconds apart, and see what the major difference is.
Thanks for the information, definitely. It's a little over my head right now, so I'm going to have to do a little research before I can address that issue.
But, I'm also thinking now that it might not be related to the LibreOffice issue, because when I tried opening up the test file and watching the CPU activity, one of the CPUs shot up to 100, but it was a different CPU.
Obviously, I still want to address it, but first I want to handle the LO issue.
LO is a symptom, not the problem. It may be causing the problem by forcing a driver/interrupt handler to be continually called, but you need to find out what that is. That workq trace should give you a pointer.
Run it for a few seconds, tar it and post the tar. It will get *very* big very fast, so 2 or 3 seconds will be plenty.
Something else might also be related-- You asked if there were any other tweaks to my system, and I remembered one that might be relevant-- I installed KATE and any KDE dependencies that are required for it to run correctly.
i had so bad experience with installing kde apps on a non-kde system, i daresay this might at least contribute to your problem.
apart from that, it seems you're on the right track with syg00, although i would rather think along the lines of "why didn't ubuntu mate set itself up properly when installed".
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.