Bug 160168 - Pivot Table Lag
Summary: Pivot Table Lag
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-03-12 13:37 UTC by J Johnson
Modified: 2024-03-28 13:48 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description J Johnson 2024-03-12 13:37:48 UTC
Description:
When loading a pivot table from a database, there is a 5-10 minute lag before getting the pop up that allows you to move the columns to the appropriate places. The table in question has around 25 data points and about 900 entries. It is being loaded over a LAN connection with a computer on the local network. The actual loading and refreshing of the table, however, only takes seconds. 

Steps to Reproduce:
1. Create and load a table in base. 
2. Put in any substantial amount of data points and entries. 20+ data points and 500+ entries.
3. Select to add a pivot table. 
4. Select the table from the database. 
5. Click okay. 

Actual Results:
Very long delay which causes LibreOffice to freeze up. After waiting 5-10 minutes, it finally loads.

Expected Results:
Relatively quick load time, given it should only be getting the table columns at that point. Again, the actual table loading once all of the columns are dropped into the pivot table happens in seconds.


Reproducible: Always


User Profile Reset: No

Additional Info:
Only happens with large tables. Small tables from the same database load the columns quickly, near instantaneous.
Comment 1 DuyN 2024-03-12 14:39:10 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Comment 2 J Johnson 2024-03-13 11:30:20 UTC
@Duyn - I see only one file is allowed to be uploaded at a time. However, this bug requires both a calc file and a database file. But the uploader only allows 1 file to be uploaded at a time. Should I upload each separately? Also, there will be some assembly required to get the database file to show up in the data sources.
Comment 3 QA Administrators 2024-03-14 03:16:18 UTC Comment hidden (obsolete)
Comment 4 Buovjaga 2024-03-20 15:02:15 UTC
(In reply to J Johnson from comment #2)
> @Duyn - I see only one file is allowed to be uploaded at a time. However,
> this bug requires both a calc file and a database file. But the uploader
> only allows 1 file to be uploaded at a time. Should I upload each
> separately? Also, there will be some assembly required to get the database
> file to show up in the data sources.

Yes, each separately.