Jump to content

Suggestion: Delete notifications earlier if read and trim size


shought

Recommended Posts

The notifications table (together with the posts table) is one of the largest tables in our IPB setup (and I can imagine this would be the same for most), so trimming it down as much as possible seems like a good idea (to avoid lookups against a large table).

So I'd like to suggest the addition of a variable which will delete notifications after x days / weeks if it has been read. This variable shouldn't replace the delete notifications after, but rather complement it. I can imagine that quite a lot of the notifications are read within 3 days after occurring, if you could remove all of these from the database this would make quite a big difference in terms of table size.

The above is my main suggestion but in addition to that it might be a good idea to make use of replacements in notifications as well, because currently standardized fulltext messages are stored in the database which causes a lot of redundancy.

Link to comment
Share on other sites

  • 2 months later...

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...