Re:Most data isn’t “big,” and businesses are wasting money p...
by mayank on Monday May 13, 2013 @01:48PM
(#5700165)
Why on earth would that be slower in a relational db? That makes no sense, since indices in both nosql and relational dbs are variants of b-trees.
Re:Most data isn’t “big,” and businesses are wasting money p...
by raverbashing on Monday May 13, 2013 @02:41PM
(#5700564)
Well, it's slower because of a join that exists in SQL (the relationship between your 'field/value' table and the entry. Apart from that, as you said indexes are similar.
The fun thing about NoSQL skeptics is how they think of only the current scenarios they work with, and they won't believe you until they get burned by it. So be it.
But why would I waste developer time doing that if I can only do db.table.insert(obj) - in MongoDB for example (obj is a JS object)
Also, finding all objects with a field named 'field1' and value '3' is slower if you do that in a relational DB (and that's the simplest case)