activity icon indicating copy to clipboard operation
activity copied to clipboard
verified publisher icon nextcloud

File location loading SLOW when it's sorted the wrong way

Open Sim0nW0lf opened this issue 4 years ago • 0 comments

Steps to reproduce

  1. Click on a picture that is sorted in last place of ~2600 pictures.
  2. See how long the load time is (so long, that I aborted at some point and found this behavior)
  3. Now change sorting of NC so that the file is on top
  4. See how it immediately shows

Expected behaviour

I expect the file location to load immediately. My guess is that all pictures are scrolled through to reach the desired image which takes a lot of time!!!

Actual behaviour

Loading times exceed expectations making me think of a timeout but I am not sure if it actually times out because it's so slow that I never waited for it to finish loading.

Server configuration detail

Operating system: Linux 4.19.0-16-amd64 #1 SMP Debian 4.19.181-1 (2021-03-19) x86_64

Webserver: Apache/2.4.38 (Debian) (apache2handler)

Database: mysql 10.5.10

PHP version:

7.4.20 Modules loaded: Core, date, libxml, openssl, pcre, sqlite3, zlib, ctype, curl, dom, fileinfo, filter, ftp, hash, iconv, json, mbstring, SPL, PDO, bz2, posix, Reflection, session, SimpleXML, pdo_sqlite, standard, tokenizer, xml, xmlreader, xmlwriter, mysqlnd, apache2handler, apcu, bcmath, Phar, exif, gd, gmp, imagick, imap, intl, ldap, memcached, pcntl, pdo_mysql, pdo_pgsql, redis, smbclient, sodium, zip, libsmbclient, Zend OPcache

Nextcloud version: 21.0.2

Updated from an older Nextcloud/ownCloud or fresh install: fresh install (Docker Apache 21 full configuration)

Where did you install Nextcloud from: latest Docker Apache image (21)

List of activated apps 
Enabled:
 - accessibility: 1.7.0
 - activity: 2.14.3
 - breezedark: 21.0.7
 - bruteforcesettings: 2.1.0
 - camerarawpreviews: 0.7.11
 - cloud_federation_api: 1.4.0
 - dav: 1.17.1
 - drawio: 1.0.0
 - external: 3.8.1
 - federatedfilesharing: 1.11.0
 - federation: 1.11.0
 - files: 1.16.0
 - files_external: 1.12.0
 - files_pdfviewer: 2.1.0
 - files_rightclick: 1.0.0
 - files_sharing: 1.13.1
 - files_trashbin: 1.11.0
 - files_versions: 1.14.0
 - files_videoplayer: 1.10.0
 - impersonate: 1.8.0
 - issuetemplate: 0.7.0
 - logreader: 2.6.0
 - lookup_server_connector: 1.9.0
 - mail: 1.9.5
 - metadata: 0.13.0
 - nextcloud_announcements: 1.10.0
 - notifications: 2.9.0
 - oauth2: 1.9.0
 - occweb: 0.0.7
 - password_policy: 1.11.0
 - photos: 1.3.0
 - previewgenerator: 3.1.1
 - privacy: 1.5.0
 - provisioning_api: 1.11.0
 - recommendations: 1.0.0
 - registration: 1.2.1
 - richdocuments: 4.1.1
 - serverinfo: 1.11.0
 - settings: 1.3.0
 - sharebymail: 1.11.0
 - sharingpath: 0.3.0
 - spreed: 11.2.2
 - support: 1.4.0
 - survey_client: 1.9.0
 - text: 3.2.0
 - theming: 1.12.0
 - twofactor_backupcodes: 1.10.0
 - updatenotification: 1.11.0
 - user_status: 1.1.1
 - viewer: 1.5.0
 - weather_status: 1.1.0
 - workflowengine: 2.3.0
Disabled:
 - admin_audit
 - calendar
 - comments
 - contacts
 - contactsinteraction
 - dashboard
 - encryption
 - firstrunwizard
 - systemtags
 - user_ldap
Configuration (config/config.php) 
{
    "htaccess.RewriteBase": "\/",
    "memcache.local": "\\OC\\Memcache\\APCu",
    "apps_paths": [
        {
            "path": "\/var\/www\/html\/apps",
            "url": "\/apps",
            "writable": false
        },
        {
            "path": "\/var\/www\/html\/custom_apps",
            "url": "\/custom_apps",
            "writable": true
        }
    ],
    "memcache.distributed": "\\OC\\Memcache\\Redis",
    "memcache.locking": "\\OC\\Memcache\\Redis",
    "redis": {
        "host": "***REMOVED SENSITIVE VALUE***",
        "password": "***REMOVED SENSITIVE VALUE***",
        "port": 6379
    },
    "instanceid": "***REMOVED SENSITIVE VALUE***",
    "passwordsalt": "***REMOVED SENSITIVE VALUE***",
    "secret": "***REMOVED SENSITIVE VALUE***",
    "trusted_domains": [
        "cloud.secureserver.de"
    ],
    "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
    "datadirectory": "***REMOVED SENSITIVE VALUE***",
    "dbtype": "mysql",
    "version": "21.0.2.1",
    "overwrite.cli.url": "https:\/\/cloud.secureserver.de",
    "dbname": "***REMOVED SENSITIVE VALUE***",
    "dbhost": "***REMOVED SENSITIVE VALUE***",
    "dbport": "",
    "dbtableprefix": "oc_",
    "mysql.utf8mb4": true,
    "dbuser": "***REMOVED SENSITIVE VALUE***",
    "dbpassword": "***REMOVED SENSITIVE VALUE***",
    "installed": true,
    "overwritehost": "cloud.secureserver.de",
    "overwriteprotocol": "https",
    "app_install_overwrite": [
        "occweb",
        "issuetemplate"
    ],
    "enable_previews": true,
    "enabledPreviewProviders": [
        "OC\\Preview\\TXT",
        "OC\\Preview\\MarkDown",
        "OC\\Preview\\OpenDocument",
        "OC\\Preview\\PDF",
        "OC\\Preview\\MSOffice2003",
        "OC\\Preview\\MSOfficeDoc",
        "OC\\Preview\\Image",
        "OC\\Preview\\Photoshop",
        "OC\\Preview\\TIFF",
        "OC\\Preview\\SVG",
        "OC\\Preview\\Font",
        "OC\\Preview\\Movie",
        "OC\\Preview\\MKV",
        "OC\\Preview\\MP4",
        "OC\\Preview\\AVI",
        "OC\\Preview\\JPEG",
        "OC\\Preview\\PNG",
        "OC\\Preview\\GIF"
    ],
    "mail_from_address": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpmode": "smtp",
    "mail_sendmailmode": "smtp",
    "mail_domain": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpauthtype": "LOGIN",
    "mail_smtpauth": 1,
    "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpport": "465",
    "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
    "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
    "mail_smtpsecure": "ssl",
    "default_phone_region": "DE",
    "maintenance": false,
    "preview_max_x": "2048",
    "preview_max_y": "2048",
    "jpeg_quality": "60"
}

Client configuration

Browser: Chrome/91.0.4472.88

Operating system: Windows 10

Sim0nW0lf avatar Jun 13 '21 10:06 Sim0nW0lf