I'm trying to get my head round how to gather together latest posts for an entire site.
It's doable by running through all the blogs and pulling out the newest posts but that's about as scalable as a 40 foot wall.
Obviously it's possible to hack the code apart and insert new posts into a new table, far more scalable but slightly more annoying and prone to various errors.
Just realising that this is an obvious problem caused by giving each blog it's own set of tables.
What I'm wondering is if anybody has done it before and could share some info on how they did it?