WebDav - slowness opening office files

Hi to All,

This is our scenario:
OC 8.1.0.8
php 5.4.16
mysql 5.5.41-MariaDB
nginx 1.8.0
HW
2vCPU - 8GB RAM
130users

Initially we were using the client for synchronization, but after numerous problems we opted for the use of webdav

The situation has improved so we decided to continue in this mode

The big problem we are seeing is the extreme slowness in the opening of all files office, and this is very often daunting (30-40seconds to open a xls)

there anything I can do to improve performance for this type of problem?

Thanks in advance

Hi,

this version is far from being recent and already unsupported [1]. To get some speed in your ownCloud installation a few suggestions:

  1. Upgrade to ownCloud 9.0.x or 9.1.x
  2. Upgrade to PHP 7.0
  3. Do ownCloud specific tunings listed here: https://doc.owncloud.org/server/latest/admin_manual/configuration_server/oc_server_tuning.html
  4. Do some generic Database, Apache and PHP tunings

[1]

thanks to the rapid response; I was hoping to avoid the upgrade for the moment, but I'll try to install a parallel demo environment; mysql or postgresql?

Hi,

if Nr. 3 and 4. doesn't help that much then i think there is no way around upgrading to a recent oC version + PHP7. There is a blogpost about performance improvements in PHP7 available at [1] which shows you a few impressions. IIRC the upcoming ownCloud 10 will bring even more performance improvements due to code optimizations.

Besides that the old 8.1.0 should be really upgraded to at least 8.1.12 [2] as this version contains various public known security vulnerabilities as shown in [3] (not even talking about the tons of known bugs :slight_smile:)

[1] https://owncloud.org/blog/php-7-is-here-and-owncloud-is-ready/

[2] https://owncloud.org/changelog/#latest8.1

[3] https://owncloud.org/security/advisories/

1 Like