News for hackers. Stuff that matters.

A comment on Now that people are considering NOSQL will more people consider no-DB. Parent comment

Re:Now that people are considering NOSQL will more people co... by colanderman on Wednesday August 31, 2011 @07:35PM (#2948044)
> Correct. For the fraction of a millisecond the transaction is executing, anyhow. Since transactions only deal with data hot in RAM, transactions are very fast.

Transactions don't just read and write. They sometimes compute things, like joins, which can take several milliseconds. These computations often must run within the transaction and would thus need to acquire the lock for several milliseconds.

[ Parent | on HN ]
Re:Now that people are considering NOSQL will more people co... by wpietri on Wednesday August 31, 2011 @08:42PM (#2948186)
Do you have a real-world example?

Joins haven't been a problem for me, mainly because this approach doesn't constrain you to a tables-and-joins model of the world. With Prevayler, for example, you treat things as a big object graph, so there are no splits to join back up.

Of course, it could be that some problem is just computationally intense, but I can think of a number of approaches to lessen the impact of that in a NoDB system.

[ Parent | on HN ]