Re: Avoiding any locks in SQL Servers - read and understand....its magic.

Guido Stepken wrote:

> With a simple benchmark test i can show, that SQL Server breaks down at
> minimum load.

You know, there are lies, damn lies and benchmarks...

 > Oracle is much better at read-write (not at write-write),
> PostgreSQL with abolute independant MVCC (write-write, write-read ist
> possible, without any locking...) is hitting the top. No locks have to
> be set in PostgreSQL, but - MVCC is the minimum requirement to implement
> MVTO.
Please point me to the PostgreSQL documentation where this is descibed.

> Setting timestamps on transactions and datasets, so a server side
> logic can time - shift transactions and rearrange data content, as if a
> lock had been set. This is a simple script in pl/SQL.

Dieter Received on Tue Aug 19 2003 - 02:24:46 CDT