MEMSQL : THE WORLD'S FASTEST DATABASE.
UP TO 1.5 MILLION TRANSACTIONS PER SECOND ON FOUR-SOCKET SERVERS.
MemSQL is a distributed, in-memory database that is part of the NewSQL movement. It is is an ACID-compliant RDBMS that most notably converts SQL into C++ through a process called code generation. MemSQL was founded in 2011 and is a graduate of the Y Combinator startup program. MemSQL has raised more than $5 million to date from a variety of investors including First Round Capital, IA Ventures, NEA, and several prominent angels including Paul Buchheit, Max Levchin, Aaron Levie, and Ashton Kutcher. MemSQL launched its database to the public on June 18, 2012.
Result of benchmark compare on my developement computer.
SQL2008R2 vs MEMSQL
INSERT INTO TestInsert VALUES (1, 'This is a test');
INSERT INTO TestInsert ( id, value ) SELECT * FROM TestInsert;
Row number get increase by 2, at each run.
computer / os :
Inter i7 2620m 2.7ghz, hdd 7200rpm. 8gb ram
windows 7 x64 professional / sql 2008r2 vs ubuntu 12.10 x64 Server / memsql