You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Queries that join on the filecache by id and filter indirectly on the storage
Files\Config\UserMountCache::getUsedSpaceForUsers: select the home folder for all users
FilesExternal\Notify::getStorageIds: joins with storages from oc_mounts and filters on mount id, can probably be replaced
Queries that join on the filecache by id and filter indirectly on the fileid
Deck\Sharing\DeckShareProvider::getShareById: join with shares, selects by share id
Spreed\RoomShareProvider::getSharesByIds: join with shares
Spreed\RoomShareProvider::getSharedWith: join with shares
Deck\Sharing\DeckShareProvider::getSharedWith: join with shares
Deck\Sharing\DeckShareProvider::getSharedWithByType: join with shares
VirtualFolder\FolderConfigManager::getAllByRootIds: join with folders
Photos\AlbumMapper::getForAlbumIdAndUserWithFiles: joins with photos
Photos\AlbumMapper::getSharedAlbumsForCollaboratorWithFiles: joins with photos
Photos\AlbumMapper::getForAlbumIdAndFileId: joins with photos
Files\Config\UserMountCache::getMountsForRootId: join fileid on mount root id
UserInfo\UserInfoManager::getUsageInfo: joins with root id from mounts and selects by mount user
UserInfo\UserInfoManager::getUsedQuota: joins with root id from mounts and selects by mount point
Files\Config\UserMountCache::getMountsForUser: join fileid on mount root id
Share\Share::getItemSharedWithUser: join on shares, select by share recipient
Share\Share::getItems: join on shares, select by share data
Share\Share::getSharedWith: join on shares, select by share recipient
Queries that select from the filecache without filtering by storage, fileid or parent
Sharing\DeleteOrphanedSharesJob: select over full table to find shares without matching filecache item
FilesAntivirus\BackgroundScanner::getUnscannedFiles: select items without matching av item
FilesAntivirus\BackgroundScanner::getToRescanFiles: select items with outdated av item
FilesAntivirus\BackgroundScanner::getOutdatedFiles: select items with outdated av item
Files\ScanFiles::getUsersToScan: select up to 1 item with size -1 from across all storages
Files\RepairTree::findBrokenTreeBits: searches through entire filecache
Files\Type\Loader::updateFileCache: select by filename LIKE and mimetype across the entire cache
Repair\RepairMimeTypes::updateMimetypes: select by filename LIKE and mimetype across the entire cache
Preview\ResetRenderedTexts::getPreviewsToDelete: filters only by path LIKE and mimetype
RepairShareOwnerShip::getWrongShareOwnership select over full table, join shares and files and mounts and find shares with wrong owner
RepairShareOwnerShip::getWrongShareOwnershipForUser same as above but limits by mount users
Files\DeleteOrphanedItems::cleanUp: select over full table to find system tags without matching filecache item
Files\DeleteOrphanedFiles::execute: select all items that don't have a storage in the storage table, join with storage table but search for NULL storage
Query that filters by parent, in most cases the storage id should be available to add to the filter
Subtask to #42920
Queries that join on the filecache by id and filter indirectly on the storage
Queries that join on the filecache by id and filter indirectly on the fileid
Queries that select from the filecache without filtering by storage, fileid or parent
Query that filters by parent, in most cases the storage id should be available to add to the filter
Queries that filter directly on multiple file ids
Queries that filter by single fileid
The text was updated successfully, but these errors were encountered: