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? :)