Bug 96341 - Version 5.1 takes a lot more RAM than version 5.0 in Windows
Summary: Version 5.1 takes a lot more RAM than version 5.0 in Windows
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.0.0.beta1
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected
Depends on:
Blocks: Memory VCL-OpenGL
  Show dependency treegraph
 
Reported: 2015-12-08 18:56 UTC by Roman Kuznetsov
Modified: 2022-06-12 08:23 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Bibisect log (18.54 KB, text/plain)
2017-10-06 12:20 UTC, Telesto
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2015-12-08 18:56:14 UTC
In Windows 7 HB x86-64 

no data:
LO Calc 5.0.4.1. use - 75 mb RAM
LO Calc 5.1 beta 2 use - 150mb RAM

with open file from link https://yadi.sk/i/rM9QctDym5y3M:

LO Calc 5.0.4.1. use - 374 mb RAM
LO Calc 5.1 beta 2 use - 454 mb RAM

In Ubuntu 15.10 this distinction is not
Comment 1 Buovjaga 2015-12-10 10:40:01 UTC
True.

Both 64-bit versions.

Version: 5.1.0.0.beta2 (x64)
Build ID: 53054959a12edc6510f51b94ddc9b73d27aedaf6
Threads 4; Ver: Windows 6.1; Render: default; 
Locale: fi-FI (fi_FI)

Win 7 Pro 64-bit, Version: 5.0.3.2 (x64)
Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75
Locale: fi-FI (fi_FI)
Comment 2 raal 2015-12-11 09:53:23 UTC
I see no problem in bibisect-win32-5.1 32bit oldest latest version, probably 64bit only problem.
Comment 3 Xisco Faulí 2016-09-13 10:24:14 UTC
Since we have a bibisect repository for windows covering the branch where this regression was introduced, adding keyword 'bibisectRequest'.
More info: https://wiki.documentfoundation.org/QA/Bibisect/Windows
Comment 4 Xisco Faulí 2017-09-29 08:48:17 UTC Comment hidden (obsolete)
Comment 5 Roman Kuznetsov 2017-10-04 09:06:11 UTC
LO Calc 5.2.6 empty new doc - 38 mb
LO Calc 5.4.1.2 empty new doc - 103 mb
LO Calc 6.0 alpha 0 (01.10.2017) empty new doc - 103 mb
Comment 6 Timur 2017-10-05 08:10:17 UTC
Please test separately WinX86 and WinX64, also with and without OpenGL and OpenCL.
Telesto confirmed his Bug 112885 with OpenCL reference is related, but not if it's a duplicate.
Comment 7 Telesto 2017-10-06 12:20:13 UTC
Created attachment 136800 [details]
Bibisect log

Lib6 x86 without OpenGL and spelling disabled need 340 MB.
With LibO 5.0.0.5 315
With 4.4.7.2 288 MB 

I did bibisect a +/15 MB difference between 4.4.7.2 - 5.0.0.5. I only got a range of possible commits...

Version: 6.0.0.0.alpha0+
Build ID: b087e451527f2e497ccab83b63b4f10099bfb8b8
CPU threads: 4; OS: Windows 6.3; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-10-03_23:43:39
Locale: nl-NL (nl_NL); Calc: CL
Comment 8 Buovjaga 2018-04-15 16:36:12 UTC
Under Win 10, 5.0.2 vs. 5.3.0 the difference (no data) is only 10 megabytes.
Yet, the cool thing is, Calc 6.1 with no data only uses 50 MB RAM. With kompi's example file Calc 6.1 uses 371 MB.

Kompi: can you check with latest master and hopefully close as WFM?

Version: 6.1.0.0.alpha0+ (x64)
Build ID: c8c74a0b4ca6f3a3619f423b6548c80c52392ae0
CPU threads: 4; OS: Windows 10.0; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-04-15_00:12:41
Locale: fi-FI (fi_FI); Calc: group
Comment 9 Roman Kuznetsov 2018-05-27 08:00:37 UTC
LO 6.1 beta 1 (64 bit) on Windows 10 (64 bit)

new empty spreadsheet - 164 mb
with open file from link - 578 mb

>_< i wanted close this bug, but for me LO 6.1 became even fatter
Comment 10 Buovjaga 2018-05-27 18:50:38 UTC
(In reply to kompilainenn from comment #9)
> LO 6.1 beta 1 (64 bit) on Windows 10 (64 bit)
> 
> new empty spreadsheet - 164 mb
> with open file from link - 578 mb
> 
> >_< i wanted close this bug, but for me LO 6.1 became even fatter

Can you try Safe Mode?
Comment 11 Telesto 2018-09-15 20:35:18 UTC
(In reply to Roman Kuznetsov from comment #9)
> LO 6.1 beta 1 (64 bit) on Windows 10 (64 bit)
> 
> new empty spreadsheet - 164 mb
> with open file from link - 578 mb

With or without OpenGL
Comment 12 Roman Kuznetsov 2018-12-02 18:50:55 UTC
Empty/500k formulas
82/296 with OGL
36/245 without OGL

in

Version: 6.3.0.0.alpha0+
Build ID: 878c36f829fd88cda95ca218a2cf03003f50e53d
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-11-24_22:47:49
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

I should check it into 64 bit build
Comment 13 aron warner 2019-07-04 05:52:33 UTC Comment hidden (spam)
Comment 14 Peter Morgan Stark 2019-11-18 21:49:02 UTC Comment hidden (spam)
Comment 15 Maurice Herve 2020-02-12 11:52:33 UTC Comment hidden (spam)
Comment 16 Maurice Herve 2020-02-12 11:53:51 UTC Comment hidden (spam)
Comment 17 QA Administrators 2022-06-01 03:37:31 UTC Comment hidden (obsolete)
Comment 18 Aron Budea 2022-06-12 04:20:38 UTC
This can be reproduced using repo bibisect-win32-5.1, the memory use when opening the start center with an empty profile is only ~16 MB before the following commit, and ~90 MB afterwards (memory use depends on whether translations are available, bibisect repos only include English language).

https://cgit.freedesktop.org/libreoffice/core/commit/?id=9639fc200b5c0779b1e60d04aa15f8f2e7868724
author		Tomaž Vajngerl <tomaz.vajngerl@collabora.com>	2015-11-20 23:01:11 +0100
committer	Tomaž Vajngerl <tomaz.vajngerl@collabora.com>	2015-11-20 23:09:27 +0100

"enable opengl by default for Windows"

I added the following to <user profile>\registrymodifications.xcu to continue:
<item oor:path="/org.openoffice.Office.Common/VCL"><prop oor:name="UseOpenGL" oor:op="fuse"><value>true</value></prop></item>

The increase from 16 -> 90 MB is with the following commit:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=7eb4c6921850a5a377f6aa42ce4af85b145da01c

author		Markus Mohrhard <markus.mohrhard@googlemail.com>	2015-06-04 17:39:48 +0200
committer	Markus Mohrhard <markus.mohrhard@googlemail.com>	2015-06-17 12:46:26 +0000

"remove all traces of old device code"

I'm inclined to believe OpenGL was simply blacklisted on my device before this.
I also believe the memory increase is due to the OpenGL feature, and trying to bibisect this further is unnecessary, not to mention OpenGL isn't even used anymore, though related pieces of code might be part of Skia now. 

Further increases in memory use might've piled onto this, but untangling why a current daily build with all languages uses 245 MB (and for some reason 530 MB with an empty profile) in the start center, will take further steps.
Comment 19 Aron Budea 2022-06-12 08:23:28 UTC
For Calc specifically there's also the following commit that increases memory use from ~120 MB to ~200 MB.

https://cgit.freedesktop.org/libreoffice/core/commit/?id=e614a1e88b13a8069ea3cf32eb04be7d43bfb335
author		Michael Meeks <michael.meeks@collabora.com>	2015-11-13 12:00:59 +0000
committer	Michael Meeks <michael.meeks@collabora.com>	2015-12-11 22:53:52 +0000

"tdf#93529 - move to a Mac-like double-buffered OpenGL model."

Concerning the memory increase between the two versions, let's go with WONTFIX.

If someone has an issue with LO's memory use in general, please file a separate bug report.