Issue 120629

Summary: Performance improvement for loading xls file with several Pivot Tables. SOT optimization
Product: Calc Reporter: Zhang Lu <zhanglu.aoo>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Major    
Priority: P3 CC: binbjguo, leiw, litan.test
Version: 3.4.0   
Target Milestone: 4.0.0   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
patch for SOT optimization none

Description Zhang Lu 2012-08-21 03:23:10 UTC
It is slow to load or save a big xls file, which contain several pivot tables, need improved.
Comment 1 binguo 2012-08-29 01:46:58 UTC
Verified on Aoo_Trunk_20120828.1800, it can repro, change status from "uncomfirmed" to "confirmed".
Comment 2 Tan Li 2012-09-12 08:32:37 UTC
Created attachment 79427 [details]
patch for SOT optimization

SOT optimization for DataPilot
Comment 3 Tan Li 2012-09-12 08:58:36 UTC
Root causes:
StgCache and Stgpage manage two lists which are of little use but will cause frequent memory page fault.

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.
Comment 4 Tan Li 2012-09-12 12:01:10 UTC
The two lists, StgPage* pCur and StgPage* pElem1, only play a role in StgCache::Commit(...); in other member methods, it waste lots of efficiency.
Comment 5 Tan Li 2012-12-03 14:22:30 UTC
Comment on attachment 79427 [details]
patch for SOT optimization

Sorry for some late doubts, needing more experiments.