Issue 85161 - Datapilot painfully slow
Summary: Datapilot painfully slow
Status: CONFIRMED
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:
URL:
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: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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
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...