Calc memory consumption

[Daniel Armando Rodriguez]

El 2021-01-22 08:18, Daniel Armando Rodriguez escribió:
> El 2021-01-21 17:35, Michael Meeks escribió:
>> On 20/01/2021 10:29, Daniel A. Rodriguez wrote:
>>>>> Hi, exists some kind of formula to estimate how much RAM a 
>>>>> spreadsheet
>>>>> could use? For instance 468K rows and columns from A to AG.
>>> 
>>> Well, trying to do something with such file using an i3 based PC with
>>> 4Gb freezes the software completely.
>> 
>> 	Both Tor and Noel are right; but I collect the 'shape' of 
>> pathological
>> spreadsheets as a hobby =)
>> 
>> 	Can you tell me:
>> 
>> 	+ what data-type is in each column
>> 	+ whether the column is sparse (ie, are
>> 	  there 'holes' in the data)
>> 	+ what formulae are used - and what their shape is ?
>> 	 	+ hopefully formulae are normally
>> 		  non-confidential
> 
> Don't have access to the file so have asked
> 
>> 	+ what file format you're using.
> 
> XLSX, it's exported from the software the company use
> 
>> 
>> 	But of course, this really doesn't belong on the dev list, but in a 
>> bug
>> if you have one ?
> 
> Nope, just acting as an intermediate in this case
> 
>> 	In case nothing jumps out of the above data, possibly running a
>> sampling profiler under Linux like 'perf' might show what's being 
>> slow,
>> though I imagine it sounds like a memory issue (perhaps even a 
>> transient
>> memory use) problem.
>> 
>> 	Thanks ! =)
>> 
>> 		Michael.



About the file, it's just a log from month activity. No formulas 
involved.


-- 
DAR