search

nextcloud / server

☁️ Nextcloud server, a safe home for all your data
https://nextcloud.com
GNU Affero General Public License v3.0
26.68k stars 4k forks source link

Move previews outside of oc_filecache #31501

Open PVince81 opened 2 years ago

PVince81 commented 2 years ago

Previews are currently stored in oc_filecache, for each file and multiple times per size.

We could move this outside of oc_filecache into a separate table and have preview specific ids or use the original file id.

In S3 primary storage we could have a different key format "preview:$fileid" for storing previews. It would even be possible for S3 admins to set a native expiration on these entries, or clean them up manually as they are distinct from the regular files.

@CarlSchwan @icewind1991 for more ideas

PVince81 commented 2 years ago

could make accessing oc_filecache faster because of less entries and also improve search