Bug 125664 - Huge memory usage when making changes to a large Calc sheet with x64 builds
Summary: Huge memory usage when making changes to a large Calc sheet with x64 builds
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.0.0.alpha1+
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Memory
  Show dependency tree / graph
 
Reported: 2019-06-03 17:06 UTC by Telesto
Modified: 2020-05-11 07:40 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2019-06-03 17:06:57 UTC 
Description:
Huge memory usage when making changes to a large Calc sheet with x64 builds

Steps to Reproduce:
1. Open attachment 150858 [details] with and x32 and X64 build
2. Select columns ABC & Copy
3. Add a new sheet & paste (repeat 3 times)
4. Compare the memory allocation. 

5. save the file
6. Reload
7.  Compare the memory allocation. (again much more memory needed on x64)

Actual Results:
x64 uses at least double as much memory as x32. 800 <-> 1700

Expected Results:
Bit more efficient if possible


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.0.0.alpha0+ (x64)
Build ID: 95462a02a3aee1e3e7f9aa8fc50ba25fee3fa592
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-06-03_07:09:38
Locale: nl-NL (nl_NL); UI-Language: en-US
Calc: CL
Comment 1 Xisco Faulí 2020-02-18 16:52:31 UTC 
Hi Telesto,
Could you please try to reproduce it with a master build from http://dev-builds.libreoffice.org/daily/master/ ?
You can install it alongside the standard version.
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the master build

Besides, could you please share your measurements on x86 and x64 ?
Comment 2 b. 2020-05-11 06:46:21 UTC 
for the Bug Hunting Session 7.0.0.0.a1+: 

didn't check against 32-bit ver, but from pure theory i'd expect a program handling values that fit in 32-bit memory in 64-bit ram to use more - double? - amount of ram? 

checked against 6.2.8.2 64-bit, inserting ten sheets and copying sheet 1 to them, 7.0.0.0.a1+ was - feeling - reasonably faster, used only half the ram, and had also only 50% of 'unfreed' ram left blocked after closing the file, 

thus i'd suggest solved, notabug or worksforme ...