Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Performance improvement for loading xls file with several Pivot Tables. SOT optimization|
|Product:||Calc||Reporter:||Zhang Lu <zhanglu.aoo>|
|Component:||editing||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||binbjguo, leiw, litan.test|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
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.