Recent comments from my blogs only

I’d like to create a list of recent comments, specific to each user on my network (Buddypress).

My best idea so far is pretty lame: DB Query on all user’s blogs, compare dates, select top 10 by date. To me, it sounds a too heavy load for the the server.

Any alternative and better ideas? 🙂

Thanks!

There’s a different posts and comments table per site, so not really.

That said, you can and should keep track of blog ids they’ve commented on in a user meta to speed things up in the first round, and cache the formatted result in a separate usermeta to speed things up in subsequent rounds. These are easy enough to be tracked and invalidate on save/delete post/comment.