Building threaded commenting system (chiragjain.tumblr.com)

When you think in terms of nosql like Cassandra, its much simpler, but I guess you are using RDBMS(which is a wise decision from manageability point of view ).