which things / settings affect the performance of calc

[newbie-02]

hi out there,

short: i would like to know if there is any list of things to take into account when working with calc, limitations, ‘good practises’, no-no’s, or similar.

long: i have an performance issue with calc, see bugs

https://bugs.documentfoundation.org/show_bug.cgi?id=125545

and

https://bugs.documentfoundation.org/show_bug.cgi?id=124692

may be it’s an old problem which is in the buglist for years - but still unresolved? - see:

https://bugs.documentfoundation.org/show_bug.cgi?id=76324

!! note: it came up during tests of the new alpha version, realeased versions may perform better, i’d like to hear about that; and if i’d like to hear about which version does … 4.1.6.2 doesn’t (crashed and freezed), who has time to do some testing? !!

i would like to know if there is any list of things to take into account when working with calc, limitations, ‘good practises’, no-no’s, or similar.

i think it’s a waste of time if other people step into the same or similar problems and have to re-create my path of pain till they get some fundamental knowledge about the tool they are working with.

and i’d like to gather information about other problems / ways to avoide before stepping in.

reg.

newbie-02

[Hrbrgr]

calc bug regarding comments? - pls. help with testing

hello @all, in particular to people interested in the performance of calc, please perform this simple test: start with an idle computer and an empty worksheet, don’t do any testing while productive work is unsaved, your system may freeze or crash!!! put ‘test’ in A1, and add the comment ‘test1’, put ‘test1’ in B1, and add the comment ‘test’, copy A1 to B2, and B1 to A2 this creates a 2x2 ‘checkerboard pattern’ of data and comments, you can click around in it, no problem, open task manager…

[newbie-02]

@Hrbrgr: funny comments ‘A: see B’, ‘B: see A’, programmatically ‘endless loop’? if the handling of comments in calc is done in a similar way it’s inescapeable to produce performance issues …

fun aside: yes, these two questions are ‘related’, but! they are targetting two very different aspects of the problem,

• one is to gather info about shortcomings in common and help to avoid them,

• the other is to get this bug tested and killed out,

reg.

b.

[newbie-02]

of course plenty!

i’m not qualified to provide a full list,

just one spot not commonly known that almost threw me off my track, and how to avoid it:

• using plenty of comments (sometimes called ‘notes’, ‘sticky-notes’, ‘post-it’s’, ‘captions’ or similar), or ‘track-change notes’ which have similar handling, can pull down calc to unusable.

it’s happening wih various impact in various versions of calc and various OS’s, best yet seen version: 6.2.7.1 win(x64).

performance issues: impressive unneeded system load on mousemoves, delayed reaction - up to 10 seconds to wait - on mouseclicks to change the focussed cell, long times to load and save, large memory footprint, doubled to tripled impact after the first save, ‘save as’, autosave or even ‘save a copy’ of the file, that reduced after a ‘close-load-cycle’,

to avoid:

estimate the size your document may grow to, estimate the count of comments and change-tracking-notes that may come up while use, double both values, create a sheet with that many filled cells, and check whether it’s response times are tolerable for your work. if not try another version, if 6.2.7.1 doesn’t suffice choose another platform

up from 5,000 comments be quite careful.

note which values are working, and keep an eye on them and check the file from time to time … with ‘Navigator’ you can check the amount of comments already in use, if you experience delays and suspect them resulting from comments make a copy of your sheet, remove all comments, and check whether it improves performance …

if other users provide other points i’ll make a list of no-no’s.

reg.

.b.

[mariosv]

This is not an answer, so please edit your question or add a comment. BTW, really you have more than 5000 comments, if every row of data has their comment, maybe they should be in a cell of the row, how to if you want to change the data to a database.