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

Hi, Joel !

Sure, i have noticed, that VMS still ist a very stable server and has clustering, is very fast....i didn't know that DEC has invented versioning, thanx....

I don't think, that oracle's locking strategy is so muc advanced, since no two transactions can write into a database at the same time ....

Did you know, that with many API's (PHP...) you cannot separate several sql statements by semicolon ? Only one statement is allowed, one resultset you can receive. You have to put 2+ statements into a stored procedure to get them executed.

regards, Guido Stepken

 >Joel Garry wrote:
> This is an excellent point, Daniel. While one could take the cynical
> view that they steered away from it to maximise profits with cheap
> technology, perhaps Guido doesn't realize that DEC was a pioneer in
> versioning, having worked with it since VMS came out at least, as well
> as a technical leader in locking strategies with Rdb. IMO in the O V7
> time frame, Rdb was much better in this respect than O. IMO, Larry
> made a shrewd investment picking Rdb up so cheap (only $100M!), and
> newer versions of Oracle are benefitting tremendously from the
> intellectual property. Oracle's default locking strategy is perfectly
> appropriate for business applications, and should not be painted with
> other vendors strategic problems.
>
> So I think you really hit the nail on the head, and this whole MVCC
> thing as argued in this thread is reinventing the wheel with some
> inappropriate spokes sticking out of the tread.
>
> jg
> --
> @home.com is bogus.
> http://www.signonsandiego.com/news/uniontrib/sun/business/news_1b17buffett.html
Received on Fri Aug 22 2003 - 18:17:53 CDT