[Libreoffice-bugs] [Bug 118662] FILESAVE - Time to save a 500Kb xlsx file has grown and causes a dump (see comment 7)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118662

--- Comment #18 from Armin Le Grand (CIB) <Armin.Le.Grand at me.com> ---
VerySleepy data:
toto-6-1 profiling statistics:

Duration: 212.859000
Date: Wed Jul 18 18:39:05 2018
Samples: 201797

toto-6-2 profiling statistics:

Duration: 277.610000
Date: Wed Jul 18 18:32:30 2018
Samples: 279161

-> 30% more time needed.
Checking SfxBaseModel::storeAsURL (central method doing the store), following
ChildCalls. Changes start at XclExpXmlStream::exportDocument:

toto-6-1 ChildCalls:

ExcDocument::ReadDoc    107.01s 51.36%  scfiltlo       
c:\lo\work06_lo-6-1\sc\source\filter\excel\excdoc.cxx   746     0x3bcec6cf
ExcDocument::WriteXml   50.24s  24.12%  scfiltlo       
c:\lo\work06_lo-6-1\sc\source\filter\excel\excdoc.cxx   832     0x3bced442
ExcDocument::~ExcDocument       47.80s  22.95%  scfiltlo       
c:\lo\work06_lo-6-1\sc\source\filter\excel\excdoc.cxx   741     0x3bce6699
oox::core::FilterBase::commitStorage    1.97s   0.94%   ooxlo  
c:\lo\work06_lo-6-1\oox\source\core\filterbase.cxx      348     0x3b668c94
std::_Tree<std::_Tmap_traits<rtl::OUString,std::pair<rtl::OUString,std::shared_ptr<sax_fastparser::FastSerializerHelper>
>,std::less<rtl::OUString>,std::allocator<std::pair<rtl::OUString const
,std::pair<rtl::OUString,std::shared_ptr<sax_fastparser::FastSerializerHelper>
> > >,0> >::clear       0.61s   0.29%   scfiltlo        c:\program files
(x86)\microsoft visual studio 14.0\vc\include\xtree    1473    0x3be841d4
XclExpRootData::~XclExpRootData 0.47s   0.23%   scfiltlo       
c:\lo\work06_lo-6-1\sc\source\filter\excel\xeroot.cxx   66      0x3be75c14
framework::StatusIndicator::start       0.14s   0.07%   fwklo  
c:\lo\work06_lo-6-1\framework\source\helper\statusindicator.cxx 51     
0x13b31520
XclExpXmlStream::CreateOutputStream     0.04s   0.02%   scfiltlo       
c:\lo\work06_lo-6-1\sc\source\filter\excel\xestream.cxx 986     0x3be7fc89
framework::StatusIndicator::setValue    0.03s   0.02%   fwklo  
c:\lo\work06_lo-6-1\framework\source\helper\statusindicator.cxx 113    
0x13b31407
framework::StatusIndicator::end 0.03s   0.01%   fwklo  
c:\lo\work06_lo-6-1\framework\source\helper\statusindicator.cxx 66     
0x13b30ec5

toto-6-2 ChildCalls:

ExcDocument::WriteXml   164.96s 60.88%  scfiltlo       
c:\lo\work01\sc\source\filter\excel\excdoc.cxx  851     0x3a1bb127
ExcDocument::ReadDoc    93.82s  34.63%  scfiltlo       
c:\lo\work01\sc\source\filter\excel\excdoc.cxx  748     0x3a1ba171
ExcDocument::~ExcDocument       10.91s  4.03%   scfiltlo       
c:\lo\work01\sc\source\filter\excel\excdoc.cxx  741     0x3a1b45f9
oox::core::FilterBase::commitStorage    0.69s   0.25%   ooxlo  
c:\lo\work01\oox\source\core\filterbase.cxx     349     0x2a177b40
std::_Tree<std::_Tmap_traits<rtl::OUString,std::pair<rtl::OUString,std::shared_ptr<sax_fastparser::FastSerializerHelper>
>,std::less<rtl::OUString>,std::allocator<std::pair<rtl::OUString const
,std::pair<rtl::OUString,std::shared_ptr<sax_fastparser::FastSerializerHelper>
> > >,0> >::clear       0.31s   0.12%   scfiltlo        c:\program files
(x86)\microsoft visual
studio\2017\community\vc\tools\msvc\14.14.26428\include\xtree   1463   
0x3a333d19
XclExpRootData::~XclExpRootData 0.13s   0.05%   scfiltlo       
c:\lo\work01\sc\source\filter\excel\xeroot.cxx  66      0x3a32675e
framework::StatusIndicator::setValue    0.08s   0.03%   fwklo  
c:\lo\work01\framework\source\helper\statusindicator.cxx        113    
0x52d19487
framework::StatusIndicator::end 0.04s   0.02%   fwklo  
c:\lo\work01\framework\source\helper\statusindicator.cxx        66     
0x52d18f45
framework::StatusIndicator::start       0.03s   0.01%   fwklo  
c:\lo\work01\framework\source\helper\statusindicator.cxx        51     
0x52d195a0

all except
ExcDocument::WriteXml   164.96s 60.88%
ExcDocument::ReadDoc    93.82s  34.63%
are peanuts.

toto-6-1 ChildCalls:
ExcDocument::ReadDoc    107.01s 51.36%
ExcDocument::WriteXml   50.24s  24.12%

toto-6-2 ChildCalls:
ExcDocument::WriteXml   164.96s 60.88%
ExcDocument::ReadDoc    93.82s  34.63%

-> ExcDocument::WriteXml got much more expensive. Why...?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180718/0b305e35/attachment-0001.html>