Is your feature request related to a problem? Please describe.
As a Nextcloud Mail admin, I want to contain the database usage of my Nextcloud installation. oc_mail_messages has many text columns, which take the bigger share of the table size.
Describe the solution you'd like
Depending on how the user sorts their messages we know what data is hot/cold. Use that as heuristic to find cold rows, and set their preview text and AI summary to null.
Regenerate the data if the user accesses the messages again (via search, scrolling).
Describe alternatives you've considered
N/a
Additional context
Is your feature request related to a problem? Please describe.
As a Nextcloud Mail admin, I want to contain the database usage of my Nextcloud installation.
oc_mail_messageshas many text columns, which take the bigger share of the table size.Describe the solution you'd like
Depending on how the user sorts their messages we know what data is hot/cold. Use that as heuristic to find cold rows, and set their preview text and AI summary to null.
Regenerate the data if the user accesses the messages again (via search, scrolling).
Describe alternatives you've considered
N/a
Additional context