Bug 95588 - .ODS with 126k rows takes 48 minutes to open (Print Spooler running)
Summary: .ODS with 126k rows takes 48 minutes to open (Print Spooler running)
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-11-04 23:06 UTC by jcdejournett
Modified: 2016-10-24 12:41 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Document containing CV of some data for given parameters (2.37 MB, application/vnd.oasis.opendocument.spreadsheet)
2015-11-04 23:06 UTC, jcdejournett
Details

Note You need to log in before you can comment on or make changes to this bug.
Description jcdejournett 2015-11-04 23:06:25 UTC
Created attachment 120276 [details]
Document containing CV of some data for given parameters

File has 126k rows, copied and pasted from the results of a SQL Server 2014 SP1 Query. Some aggregate calculations on the data are also included.
Comment 1 m_a_riosv 2015-11-05 00:07:10 UTC
Opening directly from here, included download: 25 seconds.

Win10x64
Version: 5.0.3.2 (x64) Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75

Please test resetting the user profile.
https://wiki.documentfoundation.org/UserProfile
Comment 2 jcdejournett 2015-11-05 01:05:48 UTC
Opened the sheet in an Ubuntu VM, and it loaded very quickly. I think it may be a windows only VM
Comment 3 jcdejournett 2015-11-05 01:09:52 UTC
Resetting the user profile had no effect; default profile was in use before, and renaming the current one for reset made no difference.
Comment 4 tommy27 2015-11-05 05:18:25 UTC
opened in less than 30 seconds under Win8.1 x64 using LibO 5.0.3.1

could you give more information about the system where it takes so long to open that file?
Comment 5 jcdejournett 2015-11-05 16:16:30 UTC
System is a 2012 Thinkpad T530, 8GB RAM, Intel HD 4000, i7-3520M CPU. Win 8 license obtained through Dreamspark. I went searching, and found that the "Print Spooler" service was causing the hang. After stopping it, the document loads as expected.

I still think this is a bug, but I'm not sure if it's with libreoffice, or Windows. If you can check into the print spooler service on your computer, let me know if it hangs the load.
Comment 6 tommy27 2015-11-05 20:43:07 UTC
how do I check the print spooler status?
Comment 7 jcdejournett 2015-11-05 20:45:32 UTC
Win+R, type "services.msc" and hit enter. You can also type this into your start part/start menu. Sort by name on the window that pops up. Scroll down to "Print Spooler" and right click "Properties". It should say if it's 'Running' or 'Stopped'.
Comment 8 Xisco Faulí 2016-09-11 20:43:17 UTC Comment hidden (obsolete)
Comment 9 Xisco Faulí 2016-10-10 11:14:35 UTC Comment hidden (obsolete)
Comment 10 jcdejournett 2016-10-10 14:34:44 UTC
This bug has not been NEEDSINFO for 11 months. I posted the requested specs in November 2015 along with a solution; you need to disable the Print Spooler service and the problem goes away. Please update the status to reflect this.
Comment 11 tommy27 2016-10-10 16:07:06 UTC
set the status back to UNCONFIRMED since there's still not another independent confirmation.

I assume you are still seeing this issue with latest 5.1.5 or 5.2.2 release? right?
Comment 12 Buovjaga 2016-10-24 11:37:12 UTC
Opens without abnormal delay. I have a similar machine: Thinkpad T520, but with Win 7. Print spooler is running.

Win 7 Pro 64-bit Version: 5.3.0.0.alpha1+
Build ID: 02e6c1c95993740e0dbea724b3014348c4b6559d
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-10-24_04:01:05
Locale: fi-FI (fi_FI); Calc: group
Comment 13 tommy27 2016-10-24 12:31:46 UTC
loads in a few seconds under Win7 x64 using LibO 5.1.5.2
Print Spooler was running.
Comment 14 jcdejournett 2016-10-24 12:38:38 UTC
No longer seeing this in 5.1.5. If there's going to be no triage for the original version (which may no longer be stable), I'm okay to close this bug.
Comment 15 Buovjaga 2016-10-24 12:41:45 UTC
(In reply to jcdejournett from comment #14)
> No longer seeing this in 5.1.5. If there's going to be no triage for the
> original version (which may no longer be stable), I'm okay to close this bug.

In comment 1 and 4, triagers used 5.0.3.

Even 5.1.x will soon see its last release: https://wiki.documentfoundation.org/ReleasePlan/5.1#5.1.6_release

Let's close as WFM.