Difference between revisions of "Calc/Performance/The Ou case"
From Apache OpenOffice Wiki
< Calc | Performance
(apples and oranges) |
|||
Line 6: | Line 6: | ||
References: | References: | ||
* [http://blogs.zdnet.com/Ou/?p=120 George Ou's blog entry] | * [http://blogs.zdnet.com/Ou/?p=120 George Ou's blog entry] | ||
− | * [http://www.lanarchitect.net/Examples/200264-l.sxc The test case file] (.sxc) | + | * [http://www.lanarchitect.net/Examples/200264-l.sxc The test case file] (.sxc), convert to ODF .ods for profiling |
* [http://www.lanarchitect.net/Examples/200264-l.zip Same data, but zip'ed Excel-XML] | * [http://www.lanarchitect.net/Examples/200264-l.zip Same data, but zip'ed Excel-XML] | ||
+ | Note that the numbers published in the article compare Excel .xls binary file format with Calc .ods, which is apples and oranges. | ||
Findings: | Findings: |
Revision as of 14:24, 3 April 2009
|
---|
Quick Navigation Team Communication Activities |
About this template |
Loading a large plain data file takes very long.
References:
- George Ou's blog entry
- The test case file (.sxc), convert to ODF .ods for profiling
- Same data, but zip'ed Excel-XML
Note that the numbers published in the article compare Excel .xls binary file format with Calc .ods, which is apples and oranges.
Findings:
- source/filter/xml/xmlsubti.cxx
- 38% of time spent in ScMyTables::NewColumn() because of replicated use of aTableVec[nTableCount - 1] (vector::operator[])
Note: percentage may be off due to compilation without optimization to obtain exact line numbers that may result in STLport's vector methods being differently compiled.- proposed fix: should obtain the pointer once instead.
- Similar for other places where aTableVec[xxx] is used.
- 38% of time spent in ScMyTables::NewColumn() because of replicated use of aTableVec[nTableCount - 1] (vector::operator[])
- TODO: Check all ScMyTables::.*() and ScMyTableData::.*()
- Especially for 63342857 calls to AddColumn() and NewColumn() that result in 1168654944 calls to operator[] ...
- 63081776 calls to AddColumn() originate from ScXMLTableRowCellContext::EndElement()
- Those are highly suspicious and seem to indicate that too many temporary elements are created for empty columns/cells (needs verification).