Proper handling of insert-mostly, select-recently datasetsSome kinds of large tables such as chat messages, blog entries, etc have the following characteristics. * huge number of records, huge data and index size * insert and select mostly * select from only recent data * select by secondary index (i.e. user_id) * secondary index entries are inserted in random order What are optimal ways to handle these tables? The below single large table does not perfo
