On 28 Feb 2002, Ilya Martynov wrote: > >>>>> On Wed, 27 Feb 2002 13:12:22 +0000 (GMT), Matt Sergeant <[EMAIL PROTECTED]> >said: > > >> MySQL with the new InnoDB type tables has row-level locking with full > >> transaction support as well.. > > MS> More to the point, Oracle doesn't use row level locking, it uses MVCC, the > MS> same as PostgreSQL does. By far a more advanced model, IMHO. > > Actually InnoDB like Oracle is not just row-level locking. It is MVCC > also.
Yeah I just found that out. Very cool. Also note eweek's latest benchmark showing MySQL to be as fast and scaleable as Oracle 9i (using JDBC though). One thing that Pg offers that nobody else does is Perl stored procedures. I haven't had the opportunity to try them yet, but it sounds very cool indeed to be able to write SPs in Perl. Has anyone here used those yet? -- <!-- Matt --> <:->Get a smart net</:->
