Issue 85161

Summary: Datapilot painfully slow
Product: Calc Reporter: zenyatta <rsolsn>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: eva-email, issues, kyoshida, ooo, sgautier.ooo
Version: OOo 2.3.1Keywords: performance
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 15522    
Attachments:
Description Flags
file to build datapilot very slow
none
file to build datapilot very slow none

Description zenyatta 2008-01-11 08:01:55 UTC 
We're using openoffice in a 200 clients business environment; we've to
substitute the last and most specialized excel clients installations that uses
heavily the pivot feature.

Datapilot , compared to the same pivot table, takes 10 mins against few seconds
of excel ; we've tried using the sheet as a base datasource with no results.

In this way we must buy again other excel licenses..... ;(, cause there aren't
alternatives.....
Comment 1 kyoshida 2008-01-14 14:44:34 UTC 
Can you post a test document that demonstrates the slowness?  Without that, we
won't even know where to start looking.
Comment 2 zenyatta 2008-01-14 15:10:45 UTC 
Created attachment 50856 [details]
file to build datapilot very slow
Comment 3 zenyatta 2008-01-14 15:11:08 UTC 
Created attachment 50857 [details]
file to build datapilot very slow
Comment 4 kyoshida 2008-01-15 18:09:35 UTC 
Yes, it is dog-slow.  confirming the issue.
Comment 5 niederbayern 2008-04-05 13:35:00 UTC 
Generally, one can detect, that DataPilot is extra slow when the result contains
a big number of columns and/or rows. Whereas, performance is not very much
dependant on the size of the data source.
Comment 6 sgautier.ooo 2008-10-28 16:20:59 UTC 
Hi all, 
I'm reassigning this issue to sc@, test@ is not the good owner. 
We have made some tests with 3.0 and the performance issue is still confirmed. 
Kind regards - Sophie
Comment 7 kyoshida 2009-08-31 20:51:09 UTC 
In general, the performance of datapilot depends largely on the number of unique
field members, not necessarily on the size of the source data.  Just FYI...