Apache OpenOffice (AOO) Bugzilla – Issue 82354
Transferring Data between Base an Calc with unsufficient performance (very slow)
Last modified: 2013-02-07 22:01:36 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
vsoler, any chance you could provide sample files that exhibit the problem?
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
Created attachment 57076 [details] biblio Query
@ sweigel Can you have a look?
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.