MEMSQL

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.^[1] 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.^[2] MemSQL launched its database to the public on June 18, 2012.^[3]

ref : wikipedia

Result of benchmark compare on my developement computer.

SQL2008R2 vs MEMSQL

STEP 1

INSERT INTO TestInsert VALUES  (1, 'This is a test');

STEP 2

INSERT INTO TestInsert ( id, value ) SELECT  * FROM    TestInsert;

[repeat]

Row number get increase by 2, at each run.

Result :

computer / os : 

Inter i7 2620m 2.7ghz, hdd 7200rpm. 8gb ram

windows 7 x64 professional / sql 2008r2 vs ubuntu 12.10 x64 Server / memsql