Skip to content

Shared album takes 10 seconds to load #1459

Description

@jimmz86

Describe the bug

i updated Nextcloud from 29 to 31 and now when i open a shared album it takes 10 seconds.
Its a big album with about 3000 pictures.
In the logs i can see this:
Exception dirty table reads: SELECT storage_id, root_id, user_id, mount_point, mount_id, f.path, mount_provider_class FROM *PREFIX*mounts m INNER JOIN *PREFIX*filecache f ON m.root_id = f.fileid WHERE (storage_id = :dcValue1) AND (user_id = :dcValue2)

I suspect there are files mentioned in the oc_filecache which are not there anymore and this causes the really long waiting time.
Any advice ?

Steps To Reproduce

No response

Platform

- OS:
- Browser:
- Memories Version:
- Nextcloud Version:
- PHP Version:

Screenshots

No response

Additional context

  • Any errors in the JS console?
  • Any errors in the Nextcloud server logs?

Metadata

Metadata

Assignees

No one assigned

    Labels

    performanceIssues related to performance

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions