Ask Your Question

Calc Registered Datasource (MySQL) for Pivot [closed]

asked 2014-08-29 14:44:18 +0200

alesito85 gravatar image

Hi, I'm trying to use a registered datasource to create a pivot table. I created a database connection in Base through ODBC, where I can view and edit data with no problem. However when selecting the data via either the Sheet or Query option, it takes an enormous amount of time and basically doesn't finish.

The database contains about ~100.000 rows with 27 columns. I tested with a query that limits the selection to 100 rows and that Calc does process. Also while monitoring network activity, I can see that the data from database is transfered quickly (about 20 MB) and then the CPU utilization of Calc jumps up, doing I don't know what. Even if I leave it for tens of minutes it does not finish.

On a side note, Microsoft Excel does process the data and creates a Pivot table in a few seconds. Any recommendations?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-07 01:44:49.312163

1 Answer

Sort by » oldest newest most voted

answered 2014-12-14 18:04:13 +0200

Alex Thurgood gravatar image

The answer lies in the fact that Calc loads virtually all of the data into internal memory. As you might appreciate, 100K rows * 27 columns is potentially a huge data array, one that the data structure created by the pivot table code can not process (or only very slowly).

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-08-29 14:44:18 +0200

Seen: 700 times

Last updated: Dec 14 '14