Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calc Registered Datasource (MySQL) for Pivot

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?