• Subjects maybe, but the others aren't necessarily worth the join effort. From/to come from a table with lots of data as well. And this way the system can be easily split out to another database/server for scale reasons.

    Plus we trim about every 7 days