Notice inbox
From StatusNet
[edit] Source
[edit] Notes
The notice_inbox table indexes the last X items in each users' public inbox (individual subscriptions, group subscriptions, @-replies, or remote subscriptions via twitter gateway).
Problems:
- Joining directly between user and notice was too expensive, so we want to pull up notice details separately.
- This ends up being the biggest table in production, eating up *lots* of space for both the few fields in it and significant per-row overhead.
- Trimming old items to keep the table from growing unnecessarily has been problematic; trimming rows out is very painful in the replicated environment.
We're looking at replacing this table with a more compact format which would pack notice references into a blob, for one row per user. This reduces overhead significantly but may be slightly less flexible.
