Bug 91346 - FILEOPEN slow with networked printer
Summary: FILEOPEN slow with networked printer
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-05-17 14:29 UTC by oz_dkj
Modified: 2015-05-19 17:51 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Wireshark statistics (1.26 KB, text/csv)
2015-05-19 14:03 UTC, oz_dkj
Details

Note You need to log in before you can comment on or make changes to this bug.
Description oz_dkj 2015-05-17 14:29:24 UTC
I tested with latest version v4.4.3.2, existed with previous v4.?, and has been reported for v3.5.4.2 (ask LibreOffice question 10429)

Ran some tests opening
 1) blank ODT document from Writer   or
 2) blank ODS document from Calc.
with the default printer being
 1) Microsoft XPS document writer   or
 2) HP printer connected to another PC
using Wireshark to monitor.

The rough timing was
 - ODT document always quick, ~1s
 - ODS quick when network disconnected (any printer), ~2s
 - ODS quick when default is XPS printer (any network state), ~2s
 - ODS slow when default is HP printer, ~40s
 - ODS very slow when default is HP printer and other PC turned on, ~420s

This problem may not be common due to some rarity in the combination of my network setup. But given that the ODT are fine I'd hope thereis a fix for the ODS.
Comment 1 Buovjaga 2015-05-19 09:52:20 UTC
I have HP 700 M775 as a network PC (connected to ADSL router) and experience no ODS slowness.

Win 7 Pro 64-bit, Version: 4.4.3.2
Build ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16
Locale: fi_FI

Version: 5.0.0.0.alpha1+
Build ID: 158b50763962f66515062300e265839828463efa
TinderBox: Win-x86@39, Branch:master, Time: 2015-05-19_00:28:31
Locale: fi-FI (fi_FI)
Comment 2 Jan 2015-05-19 11:11:52 UTC
Hi,

can you provide use with a dump from wireshark? What is it actually transmitting? May be we can find the corresponding code using that data.


Thanks,
Jan
Comment 3 oz_dkj 2015-05-19 14:03:32 UTC
Created attachment 115715 [details]
Wireshark statistics

IP addresses have been redacted - hopefully without losing meaning.
www.router is the IP address on world wide web for domain .<router name>
Comment 4 oz_dkj 2015-05-19 14:07:09 UTC
Bad terminology: not network printer, but shared printer on host PC.

Ran tests multiple times, and always Calc tried to talk to host PC (NBNS PC, DNS PC in varous forms) starting within a second of opening file. Enquiries about host PC never happened in control tests when Calc not open.

Housemates would prefer to share a minimum so I hope the Wireshark statistics from two runs will suffice. File opening was at 1~2s.

Not surprised by Beluga's report - guess that some rare combination of network setup results in it being slow for me, which is just sad for me. However Calc has no reason to talk to printer host PC so there is a bug, which would solve my performance problems.
Comment 5 Jan 2015-05-19 14:10:24 UTC
Is it resolving your hostname? Is the hostname resolvable? May be related to #47179?
Comment 6 oz_dkj 2015-05-19 17:51:47 UTC
Not reproducible. Possibly Microsoft hiccup.

Made two changes
1) Connected to printer host through file explorer
 - it asked for credentials (did it before?)
 - gave access only to net-shared folder rather than whole of <me in users> like
   before
Calc then opened file well under all conditions (default printer HP, host PC on).

2) Swapped Win 8.1 laptop from Live ID to local account and back again on theory that superseded local credentials may have been a factor. Calc still working well.

Now Calc opens documents quickly without enquiring about printer host. So cannot reproduce problem - something peculiar to my history with/and Calc. Would guess that change (1) above was the relevant one, and that the underlying glitch was Microsoft networking between 8.1 and XP fixed by updates recent (month ago) to printer host.