In our last post, Bradley described how auto increment works
in TokuDB. In this post, I explain one of our implementation’s
big benefits, the ability to combine better primary keys with
clustered primary keys.
In working with customers, the following scenario has come up frequently. The user has data that is streamed into the table, in order of time. The table will have a primary key that is an auto increment field, ‘id’, and then have an index on the field ‘time’. The queries the user does are all on some range of …[Read more...]