[Libreoffice-bugs] [Bug 140071] New: Too long to get data when it get 'Refresh' on pivot table option

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=140071

            Bug ID: 140071
           Summary: Too long to get data when it get 'Refresh' on pivot
                    table option
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dnroa at y7mail.com

Description:
Aproximately 10 minutes take to have new data from mysql database, store and
manage using libreoffice base for other users, in colaborate mode.

The pivot table is configured in a libreoffice Calc table which point to mysql
database, using jre class pluging JDBC, configured in Calc previously. 

Steps to Reproduce:
1.Insert or Edit any data, using libreoffice Base,using Forms. 
2.After store the data, got to libreoffice Calc file.
3.Right click on pivot table place, and the get "Refresh"


Actual Results:
Take around 10 minutes to get data. It doesn't matter if it is a large amount
of data.

Expected Results:
Get the data on pivot table in seconds, that is te same amount of time when you
get data in libreoffice Base, when you run a Query


Reproducible: Always


User Profile Reset: No



Additional Info:
I'm using query to get data on pivot tables in libreoffice calc.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210201/4f7e59e2/attachment.htm>