I would keep it simple on the tech side, and would probably stick with an SQL DB, along with a solid full text indexing service running separately for search.

From a UI perspective, I would probably also improve the way threads are shown, as currently I find it impossible to follow conversations on Twitter.