Re:VoltDB. Speed = 100x MySQL & 13x Cassandra & 45x Oracle
by Retric on Wednesday June 30, 2010 @10:46AM
(#1474961)
I get where you are coming from, however if your application is already using SQL then the transition to a more limited but faster database is a lot simpler than going to NoSQL.
Also one of the simple hacks to increase speed is to have a smaller working set database on a separate system to handle more recent items. Because it's under a much higher load the "live" database tends to have really simple usage pattern also due to its smaller size it tends to fit into RAM. And, the “Live” DB tends to have different optimizations (EX: Fewer indexes because you have more writes). Based on this a "striped down" but still SQL database seems like a perfect fit.
PS: It's a lot like Memcached, something that can speed up your application with minimal development time is worth a lot.
My intent was to make the claim that VoltDB is a feature subset of a relational database and is overhyped in the same lines that many NoSQL servers are. It's just a different subset of features than the key/value store servers.
My point boils down to VoltDB is merely another option if you have corners you can cut from the normal relational database model.
I probably could have been more clear in stating that. Bringing mongodb into the discussion muddied things.