Issue 40682 - OOo very slow by accessing database
Summary: OOo very slow by accessing database
Status: CLOSED DUPLICATE of issue 51151
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m69
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-01-14 15:23 UTC by davide
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

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

Attachments
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 davide 2005-01-14 15:23:34 UTC 
I've a large table (about 800K lines) that I commonly use for generating pivot
table under Excel. The table is contained inside an Access Database.
The pivot table with an avarage operation is performed in about 2 minutes.

I've ported the table into a DBF and MySQL database in order to perform te same
operation with Calc.
The same operation is performed in about 10 hours which means that the OOo
access to the database it's very very slow with respect to Excel/Access.

I've tried to perfom the operation with several different configuration:

- Linux and Windows
- OOo 1.1.4 and 1.9.69
- ODBC, JDBC and native support

The result is always the same: it's impossible to elaborate a large mass of data
comining from DB.

I've also tried to move data from a DBF table to a MySQL table with drag and
drop: about 6 hours of time needed.

Davide
Comment 1 alex.thurgood 2005-01-17 21:18:08 UTC 
I have noticed similar performance problems with an Excel file containing 3000
lines on Mac X11 OOo 1.1.3 compared to native Mac Excel, it is excruciatingly
painstaking even just to filter on one criteria. This has made it unusable at my
workplace for my colleagues.

I have since converted the base to a mysql table including a primary
auto-increment key where performance is better.
Comment 2 marc.neumann 2005-06-23 13:45:57 UTC 
I set this issue to duplicate to issue 51151. In the new issue I have create a
defined test datenbank and have measure the time ffor each action.



*** This issue has been marked as a duplicate of 51151 ***
Comment 3 marc.neumann 2005-06-23 13:49:22 UTC 
close