dimanche 6 janvier 2013

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 BuchheitMax LevchinAaron Levie, and Ashton Kutcher.[2] MemSQL launched its database to the public on June 18, 2012.[3]


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


Aucun commentaire:

Publier un commentaire