hashtags, infinite scrollback paged chatrooms. All of these are very hard to do without having some kind of limit option with implied created_at desc ordering in a query.