News for hackers. Stuff that matters.
Re:VoltDB. Speed = 100x MySQL & 13x Cassandra & 45x Oracle by epochwolf on Tuesday June 29, 2010 @05:32PM (#1472920)
> Suggesting there is no difference between a Key Value store and an SQL database capable of ad hock queries, Transactions, and Joins is ridiculous.

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.

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.