By RajuTJ
via toolsjournal.com
Published: Jun 19 2012 / 17:54
MemSQL, a new breed of databases has gone live today that uses an abstract framework that combines processing speed and robust SQL interfce within an in-memory data tier to achieve actionable insights at rates 30 times faster than with disk-backed alternatives.
Comments
Yurik Tyrant replied ago:
"translates SQL into C++" ???
openid-provider.appspot.com/vasili@memsql.com replied ago:
That is correct. Unlike traditional SQL implementations which interpret query trees at run time to evaluate SQL queries, MemSQL auto-parameterizes the SQL query, translates SQL into C++ code, compiles that code into a shared object. The shared object is cached and used to evaluate the query and other similar queries. By similar I mean queries that can be evaluated using the same generated code but with different parameters. For example these 3 quereis will require only one compilation:
select * from my_table where col = 101;
select * from my_table where col = 102;
select * from my_table where col = 103;
What's more is that shared objects are cached durably on disk, so you can stop or kill the server, start it back up and run your workload without recompiling queries again.
Voters For This Link (3)
Voters Against This Link (1)