Issue 85161 - Datapilot painfully slow
Summary: Datapilot painfully slow
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.3.1
Hardware: All All
: P3 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: performance
Depends on:
Blocks: 15522
  Show dependency tree
Reported: 2008-01-11 08:01 UTC by zenyatta
Modified: 2013-08-07 15:13 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

file to build datapilot very slow (740.56 KB, text/plain)
2008-01-14 15:10 UTC, zenyatta
no flags Details
file to build datapilot very slow (740.56 KB, application/octet-stream)
2008-01-14 15:11 UTC, zenyatta
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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...