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,
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    
Description Flags
file to build datapilot very slow
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
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 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...