Issue 82354 - Transferring Data between Base an Calc with unsufficient performance (very slow)
Summary: Transferring Data between Base an Calc with unsufficient performance (very slow)
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.3.0 RC1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2007-10-07 14:33 UTC by vsoler
Modified: 2013-02-07 22:01 UTC (History)
5 users (show)

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

Attachments
biblio Query (2.36 KB, application/vnd.sun.xml.base)
2008-10-09 06:52 UTC, amy2008 		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 vsoler 2007-10-07 14:33:59 UTC 
It's a great idea that you can query a Base database from Calc using the 
Datapilot.

However, in Win XP, the process takes ages and hangs up. I am obliged to close 
the Calc program after waiting, say, 10 minutes, with Ctrl-Alt-Del.

When I'm in my office, using Win NT or Win 2000, it is terribly slow, but it 
works.

Improving performance, IMHO, is a must.

Regards
Comment 1 kpalagin 2008-01-22 14:26:22 UTC 
vsoler,
any chance you could provide sample files that exhibit the problem?
Comment 2 amy2008 2008-10-09 06:49:38 UTC 
How to reproduce,
1 Open biblio.odb and select "Queries" via "Create Query in Design View" to 
create a new query named "biblioQuery"
2 Create a new Calc file, Data -> Datapilot -> Start，"Select Source" dialog 
pops up, then pitch on "Data source registered in OpenOffice.org", 
click "ok", "Select Data Source" dialog appears, 
Database is Bibliography; Type is Query, then you can find "biblioQuery" in 
Data Source
click "OK" 
3 DataPilot dialog appears, you can select items what you want, then click "OK" 

vsoler, if my reproducing steps is the same as yours, I would say this issue is 
not reprocucible. if not, would you like describing how to reproduce it step by 
step ASAP?
Li Meiying
Comment 3 amy2008 2008-10-09 06:52:02 UTC 
Created attachment 57076 [details]
biblio Query
Comment 4 Mechtilde 2009-06-22 17:07:17 UTC 
@ sweigel

Can you have a look?
Comment 5 Stefan Weigel 2009-06-23 08:27:37 UTC 
From what I understand, this issue is *not* related to the combination of
DataPilot and Base.

First of all, there are performance issues with DataPilot, no matter if the data
origin from a table in Calc or from some registered data source. For example see
issue #85161.

But, in general, transferring data from Base to Calc or vice versa performs
very, very slow.

Quick test: Create 30.000 recordsets of random data in Calc. Create a new
database in Base. Copy the data from Calc to Base. On my machine this takes
about 10 minutes (Windows 2000, OOo 3.1.0)

Quick test vice versa: In Calc press F4 for the Data Sources View. Drag&Drop the
table from the database to the spreadsheet. Again: 10 minutes.

As a consequence, when using DataPilot with this data from Base, you will face a
delay of 10 minutes every time DataPilot needs to query the data. But the reason
is *not* related to DataPilot.

Changing Summary.

IMO not duplicate but somehow related are issues #51151, #53779, #40682.