New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Add owner, file_id index to oc_photos_albums_files #2445

Open

juliushaertl opened this issue Apr 22, 2024 · 0 comments

Labels

1. to develop performances

Member

juliushaertl commented Apr 22, 2024

There are queries that get executed regularly on share removal which do not use an index:

Screenshot 2024-04-22 at 10 23 43

photos/lib/Album/AlbumMapper.php

Line 320 in c77b904

->where($query->expr()->eq("owner", $query->createNamedParameter($ownerId)))

Adding a combined index for owner, file_id should solve this

juliushaertl added 1. to develop performances labels

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment