[Home] [Groups] - Message: [Prev in Group] [Next in Group]

nu.kanga.list.mud-dev

24656: RE: [MUD-Dev] Re: The total DBMS approach

[Full Header] [Plain Text]
From: Daniel.Harman@barclayscapital.com
Newsgroups: nu.kanga.list.mud-dev
Date: Thu, 15 Aug 2002 09:54:25 +0100
Organization: Kanga.Nu
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@kanga.nu
https://www.kanga.nu/lists/listinfo/mud-dev