Issue 102716 - Calc is very slow for some operations (with many notes)
Summary: Calc is very slow for some operations (with many notes)
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO310m11
Hardware: PC Windows XP
: P4 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: performance, regression
Depends on: 109276
Blocks:
  Show dependency tree
 
Reported: 2009-06-12 13:20 UTC by sukender
Modified: 2019-06-04 01:04 UTC (History)
8 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.6
Developer Difficulty: ---

Attachments
Example file with many notes. Try deleting a line for instance (114.93 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-06-18 20:27 UTC, sukender 		no flags Details
Similar file with normal text instead of notes. Use this file to compare the execution time. (20.00 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-06-18 20:28 UTC, sukender 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description sukender 2009-06-12 13:20:10 UTC 
On some quite big spreadsheets, the application is awfully slow for some 
operations, comparing to OOo 3.0. Test machine is a Pentium 4 at 3.4 GHz (1 
core). Two formats (XLS and ODS) have been tested, and the results are the same.

In each case, csrss.exe takes ~80% of the CPU!

For example, in one of our spreadsheets (>15k lines, >35 cols, 15.5 MB in XLS 
or 5.43 MB in ODS) :

1. the loading of the spreadsheet takes much time at the end (~ 1 minute), 
after the 3 progress bars have been to 100% (The last one is named "calcul" in 
French, so maybe "Compute" in English).

2. Adding or removing a line takes much time (~ 3 minutes).

3. And copy-paste too.

For this kind of spreadsheet, we were forced to revert to OOo 3.0.
Comment 1 Joost Andrae 2009-06-13 23:42:37 UTC 
please attach an example to this issue
Comment 2 sukender 2009-06-18 15:08:09 UTC 
Sorry, I just can't send the given spreadsheet since its content is private. 
However, I'll try to create ASAP a spreadsheet that reproduces the bug.
Comment 3 sukender 2009-06-18 20:26:39 UTC 
I just identified more precisely the problem: It comes from notes added on 
cells.
To reproduce, add a note to a cell and copy the cell to many (say 10000). The 
csrss.exe process takes then much CPU and the copy operation is much slower 
than copying a cell that only contains text (no note). Deleting or inserting a 
line : same thing.
Saving the file (and maybe loading too) is also slow, but csrss isn't affected.
Comment 4 sukender 2009-06-18 20:27:41 UTC 
Created attachment 63076 [details]
Example file with many notes. Try deleting a line for instance
Comment 5 sukender 2009-06-18 20:28:32 UTC 
Created attachment 63077 [details]
Similar file with normal text instead of notes. Use this file to compare the execution time.
Comment 6 wope 2009-06-24 02:05:33 UTC 
can confirm it
Comment 7 camillem 2009-07-07 11:41:02 UTC 
@sukender : could you please add the keyword "regression" to this issue?
Comment 8 daniel.rentz 2010-05-05 19:38:25 UTC 
BTW: I am pretty sure that it is the "soffice" process that eats so much time ;-)
See issue 111390 for explanation. I will take this issue for the bug document.
Comment 9 daniel.rentz 2011-03-17 09:53:27 UTC 
Can confirm the performance problems. Unfortunately, this cannot be solved easily due to the current implementation.
Comment 10 Oliver Brinzing 2011-06-24 06:13:20 UTC 
.
Comment 11 b. 2019-06-03 21:08:41 UTC 
retested this bug today with AOO416m1(Build:9790)  -  Rev. 1844436
2018-10-23 12:57 under win7 pro (x64) SP1, still an issue, pls. see add. comments in #128121, could somebody pls. recheck and raise priority? 
see also #109276