[sc-issues] [Issue 97886] Datapilot memory leak in O Oo Calc

2009-01-09 Thread pvrohr
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=97886
 Issue #|97886
 Summary|Datapilot memory leak in OOo Calc
   Component|Spreadsheet
 Version|DEV300m37
Platform|PC
 URL|http://n.ethz.ch/student/pvrohr/OOoML/
  OS/Version|Windows Vista
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|open-import
 Assigned to|spreadsheet
 Reported by|pvrohr





--- Additional comments from pvr...@openoffice.org Fri Jan  9 09:05:00 
+ 2009 ---
When starting or refreshing a series of datapilots which are accessing an OOo
Base database, OOo Calc consumes all available memory and just freezes. 

The problem occurs on:
- lenovo thinkpad t400 (4gb ram) under vista business sp1 using OOo Dev300m37
- acer aspire 5000 (1gp ram) under xp sp3 using OOo 3.0

An example spreadsheet with the respective database is available in a zip-file
under:
http://n.ethz.ch/student/pvrohr/OOoML/

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[sc-issues] [Issue 97886] Datapilot memory leak in O Oo Calc

2009-01-09 Thread pvrohr
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=97886





--- Additional comments from pvr...@openoffice.org Fri Jan  9 09:08:18 
+ 2009 ---
Created an attachment (id=59258)
zip-file with spreadsheet and database


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[sc-issues] [Issue 97886] Datapilot memory leak in O Oo Calc

2009-01-09 Thread aladdin2k7
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=97886





--- Additional comments from aladdin...@openoffice.org Fri Jan  9 09:59:59 
+ 2009 ---
Confirmed on OOo 2.4.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[sc-issues] [Issue 97886] Datapilot memory leak in O Oo Calc

2009-01-09 Thread er
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=97886


User er changed the following:

What|Old value |New value

  CC|''|'kohei'





--- Additional comments from e...@openoffice.org Fri Jan  9 11:38:04 + 
2009 ---
@kohei: is this related to (and maybe fixed with) issue 93998?

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[sc-issues] [Issue 97886] Datapilot memory leak in O Oo Calc

2009-01-09 Thread kohei
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=97886


User kohei changed the following:

What|Old value |New value

  Ever confirmed|  |1

  Status|UNCONFIRMED   |NEW





--- Additional comments from ko...@openoffice.org Fri Jan  9 14:36:44 + 
2009 ---
@er: I'm not sure.  The fix in issue 93998 is mostly effective on sheet data
source and/or data with lots of duplicate or empty rows.  The example data is a
database with no duplicate rows, so that fix wouldn't have been effective.

Having said that, when refreshing datapilot output with Base data, it takes some
time to refresh, but eventually it finishes.  But I admit, it still uses a lot
of memory and we should probably find more ways to reduce memory footprint 
there.

Just to provide a data point, on my system (openSUSE 11.0), the memory use
before refreshing was 248 MB, and it rose to 1.2 GB after refreshing.

What's interesting is that this problem already existed in 2.4 (according to
aladdin2k7's comment).  That version doesn't use cache tables, so the problem
may not be just in the cache table implementation.  Maybe the result calculation
code is using too much memory?  I don't know...

Sounds a little like Issue 55266 at first glance.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org