shought Posted January 4, 2013 Share Posted January 4, 2013 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 More sharing options...
shought Posted March 25, 2013 Author Share Posted March 25, 2013 Bump Link to comment Share on other sites More sharing options...
Samourai Posted March 26, 2013 Share Posted March 26, 2013 I totally agree with the main idea. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.