Issue 105180 - Deleting a sheet by API => memory loss
Summary: Deleting a sheet by API => memory loss
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.1.1
Hardware: PC Windows, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-18 14:57 UTC by bmarcelly
Modified: 2013-12-19 08:39 UTC (History)
2 users (show)

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

Attachments
Spreadsheet with 100 pages and a macro to delete 99 (13.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-09-18 14:58 UTC, bmarcelly 		no flags Details
Memory consumption due to page delete by API (15.31 KB, image/png)
2009-09-18 14:59 UTC, bmarcelly 		no flags Details
Screenshot of Windows Task Manager (182.18 KB, image/png)
2013-12-19 08:39 UTC, Edwin Sharp 		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 bmarcelly 2009-09-18 14:57:00 UTC 
Next attachment is a spreadsheet with 100 pages, containing a small Basic macro.
If you delete 99 sheets with the user interface, no problem.

If you delete 99 pages by API there is a memory loss of 300 Mbytes, recovered when 
you close or reload the document after execution.
Deleting more sheets (e.g. 200) may use all memory.

On version 2.4.3 the same code consumes "only" 80Mbytes.
No memory consumption with good old version 1.1.5, and it runs quicker.

No memory consumption with the equivalent code for Draw.
Comment 1 bmarcelly 2009-09-18 14:58:16 UTC 
Created attachment 64842 [details]
Spreadsheet with 100 pages and a macro to delete 99
Comment 2 bmarcelly 2009-09-18 14:59:42 UTC 
Created attachment 64843 [details]
Memory consumption due to page delete by API
Comment 3 Edwin Sharp 2013-12-19 08:38:22 UTC 
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1551017
Rev.1551017
Win 7
Comment 4 Edwin Sharp 2013-12-19 08:39:26 UTC 
Created attachment 82134 [details]
Screenshot of Windows Task Manager