Custom Options->Libre Office->Memory settings?

[EasyTrieve]

Does anyone have any good suggestions for how to go about choosing settings for memory?

I tried a few different settings for memory, but am not sure how to choose good settings.

The Help for this dialog (snapshot below) is pretty unhelpful I think:

---

I am having an issue where LO hangs for many seconds at a time, and then resumes, as if it is doing extended garbage collection. Sometimes it even hangs and issues the Force Quit? dialog, lol, to which I say no, and then if I wait awhile it resumes. It does not crash.

I suppose it could also be a bug, but it occurs randomly, except that it’s predictable after a few edits. Edit, Edit, Edit, … hangs for awhile, resumes.

It sure looks like garbage collection running amuck. I’ve also attached a snap of the CPU activity of my machine as this happens. Curiously it runs CPU1 for awhile, with CPU2 mostly idle, then swaps activity and runs CPU2 while CPU1 is idle, then again and again, never running them both much at the same time.

LO 5.4.4.2 / Linux Debian Stretch 9.3

[EasyTrieve]

@mikekaganski & @librebel, I just found the source of this extreme slowness. My report had 3 grouping levels with 10 accumulation subtotal functions, some with custom functions. The function property Pre evaluation was set by default to Yes on these 10 accumulators. When I set it to No, suddenly the system had 1000x improvement in speed, strangely both in saving my design edits, and in running the reports. It was a real surprise that this could cause both of these slowdowns.

[mikekaganski]

This should be the answer to a more specific question - with details where the options are. It would be of great help to many.

[mikekaganski]

There are no good suggestions about those settings, because they are used for image and OLE object caches. Nothing else.

I have removed the page altogether from 6.0 to stop confusing users about those settings. The settings are available now only in Expert configuration, for those exceptionally rare cases when they are actually useful.

LibreOffice main code doesn’t use GC (it is C++, and uses smart pointers that destroy objects immediately after they aren’t used anymore). GC is used in Java, of course, but I couldn’t imagine a scenario where you’d see LO freezing because of that (well, there are many things existing in the world I cannot imagine :))

The best would be to try to debug the problem, including getting backtrace for those moments when program freezes.

[EasyTrieve]

Thanks Mike. This helps.

[librebel]

Hello @EasyTrieve,

i also get that “Force Quit or Wait” dialog popping up regularly in LibreOffice, especially when i also have Firefox running at that time.

Firefox plus 4 instances of “Web Content” together take up 1400 Mb of memory, while soffice.bin uses only 240 Mb of memory on my system.

In my case, it seems that Firefox is the main culprit, because these symptoms do not occur anymore after i quit Firefox, while continuing with LibreOffice.

Are you perhaps using Firefox too ?

I saw that your “Number of Objects” under “Cache for Inserted Objects” is set to 500 ( mine is set to 15 ).
Unless one day you decide to insert 500 OLE Objects into your document, this number could be decreased to free up some memory.

HTH, lib

[EasyTrieve]

@librebel, Hi. I also noticed Firefox being a problem, esp. w/ multiple tabs open, but also some tabs are worse than others and run lots of javascript. You can enter about:performance into the url box to have Firefox look for tabs with bloat and be asked if you want to close them.

But unfortunately, at the time of my tests above I didn’t even have Firefox open, or anything else, so as to help isolate what was going on.

Thanks!

[librebel]

Thanks for the tab about:performance, i tried several ways to decrease FF memory usage through the years, currently migrating 90% of my tabs to addon “OneTab”…