[MUD-Dev] Re: The total DBMS approach

[Daniel.Harman at barclayscapital.com]

From: Hanz, Rob

> As of version 4.0, MySQL can use row-level locking, if you use the
> InnoDB handler.  It also has support for transactions, meaning the
> only major functionality missing is stored procedures and nested
> select statements.

Hmm, how do you make a properly n-tier app without sprocs? Do people
using MsSQL really have to embed the SQL in their code as that
doesn't sound maintainable or easy to optimise (as you can't let a
DBA optimise your queries independantly of you).

Furthermore, I was under the impression that using sprocs allowed
the RDBMS to optimise queries more effectively than SQL squirted
directly down to it.

This omission seems like quite a deterant to using the product.

Dan
_______________________________________________
MUD-Dev mailing list
MUD-Dev at kanga.nu
https://www.kanga.nu/lists/listinfo/mud-dev