Re: TPC-A and -B Benchmarks

In-Reply-To: NLUNIX:rmy.emory.edu!ilist@sun4nl.nl.oracle.com's message of 07-07-93 15:51 What strikes me the most is that all messages about the subject of repeatable reads, read consistency, cursor stability, isolation levels etc, all discuss 'how a database should implement a certain feature' instead 'whats the purpose of a feature'. I don't see why you should use locks to implement repeatable reads. Locking is just one way (and I don't think it is the best way) Multiversioning, like Oracle implements is another way, which will not cause any locks. The main reason why you use something like this is to retrieve the correct data, not because you'd want to lock data. Superfluous locking of data (even row locks) will cause serious performance degradation. -- These opinions are just mine and not of Oracle Corporation --- Sandor Nieuwenhuijs Oracle Netherlands