You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/08/21 05:23:10 UTC
[Bug 120629] New: Performance improvement for loading and saving for
xls file with several Pivot Tables
https://issues.apache.org/ooo/show_bug.cgi?id=120629
Priority: P3
Bug ID: 120629
Assignee: ooo-issues@incubator.apache.org
Summary: Performance improvement for loading and saving for xls
file with several Pivot Tables
Severity: major
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: zhanglu.aoo@gmail.com
Hardware: All
Status: UNCONFIRMED
Version: AOO 3.4.0
Component: editing
Product: spreadsheet
It is slow to load or save a big xls file, which contain several pivot tables,
need improved.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120629] Performance improvement for loading xls file with
several Pivot Tables. SOT optimization
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120629
Wang Lei <le...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Performance improvement for |Performance improvement for
|loading and saving for xls |loading xls file with
|file with several Pivot |several Pivot Tables. SOT
|Tables |optimization
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120629] Performance improvement for loading xls file with
several Pivot Tables. SOT optimization
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120629
--- Comment #5 from Tan Li <li...@gmail.com> ---
Comment on attachment 79427
--> https://issues.apache.org/ooo/attachment.cgi?id=79427
patch for SOT optimization
Sorry for some late doubts, needing more experiments.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120629] Performance improvement for loading and saving for xls
file with several Pivot Tables
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120629
Wang Lei <le...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |leiw@apache.org
Issue Type|DEFECT |ENHANCEMENT
Target Milestone|--- |AOO 3.5.0
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120629] Performance improvement for loading and saving for xls
file with several Pivot Tables
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120629
binguo <bi...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |binbjguo@gmail.com
Ever confirmed|0 |1
--- Comment #1 from binguo <bi...@gmail.com> ---
Verified on Aoo_Trunk_20120828.1800, it can repro, change status from
"uncomfirmed" to "confirmed".
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120629] Performance improvement for loading xls file with
several Pivot Tables. SOT optimization
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120629
Tan Li <li...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #79427| |review?
Flags| |
--- Comment #2 from Tan Li <li...@gmail.com> ---
Created attachment 79427
--> https://issues.apache.org/ooo/attachment.cgi?id=79427&action=edit
patch for SOT optimization
SOT optimization for DataPilot
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120629] Performance improvement for loading xls file with
several Pivot Tables. SOT optimization
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120629
Tan Li <li...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #79427|0 |1
is obsolete| |
Attachment #79427|review? |
Flags| |
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120629] Performance improvement for loading xls file with
several Pivot Tables. SOT optimization
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120629
Tan Li <li...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |litan.test@gmail.com
--- Comment #3 from Tan Li <li...@gmail.com> ---
Root causes:
StgCache and Stgpage manage two lists which are of little use but will cause
frequent memory page fault.
Solutions:
Don't use the two lists, but only use member pLRUCache of class StgCache to
process cache update. This greatly simplify StgCache creation when DataPilot
import.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120629] Performance improvement for loading xls file with
several Pivot Tables. SOT optimization
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120629
--- Comment #4 from Tan Li <li...@gmail.com> ---
The two lists, StgPage* pCur and StgPage* pElem1, only play a role in
StgCache::Commit(...); in other member methods, it waste lots of efficiency.
--
You are receiving this mail because:
You are the assignee for the bug.