CREATE TABLE ... TTL n HOUR(S)/DAY(S)/WEEK(S)/MONTH(S)/YEAR(S)
CREATE TABLE ... TTL nH/D/W/M/Y
ALTER TABLE ... SET TTL ...

1 JDBC inserters, 1 selectors. 10 seconds runtime.

batch size = 1:

vi_ttl, no TTL:
JDBC: 12,483 inserts per second, 14,071 selects per second
ILP: 7,994 inserts per second, 14,691 selects per second

vi_ttl, huge TTL:
JDBC: 12,621 inserts per second, 14,090 selects per second
ILP: 7,779 inserts per second, 15,361 selects per second

master:
JDBC: 13,156 inserts per second, 14,785 selects per second
ILP: 8,326 inserts per second, 15,636 selects per second


batch size = 10:

vi_ttl:
JDBC: 120,721 inserts per second, 16,125 selects per second
ILP: 79,141 inserts per second, 15,248 selects per second

vi_ttl, huge TTL:
JDBC: 119,435 inserts per second, 15,497 selects per second
ILP: 78,679 inserts per second, 15,415 selects per second

master:
JDBC: 109,914 inserts per second, 14,353 selects per second
ILP: 78,835 inserts per second, 15,377 selects per second


batch size = 100:

vi_ttl, no TTL:
JDBC: 542,487 inserts per second, 14,565 selects per second
ILP: 669,285 inserts per second, 15,384 selects per second

vi_ttl, huge TTL:
JDBC: 522,093 inserts per second, 13,816 selects per second
ILP: 659,954 inserts per second, 14,897 selects per second

master:
JDBC: 514,009 inserts per second, 14,604 selects per second
ILP: 660,710 inserts per second, 15,548 selects per second