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: ---
Attachments:
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.

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.
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.