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)
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:
Keywords: oooqa
Depends on:
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: ---

biblio Query (2.36 KB, application/vnd.sun.xml.base)
2008-10-09 06:52 UTC, amy2008
no flags Details

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 

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 

Improving performance, IMHO, is a must.

Comment 1 kpalagin 2008-01-22 14:26:22 UTC
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", 
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.