From: kevin lyda (kevin+dated+1032396044.9d7881 at domain ie.suberic.net)
Date: Sat 14 Sep 2002 - 01:41:16 IST
On Fri, Sep 13, 2002 at 10:44:26PM +0100, Matthew French wrote:
> Just to defend my statements on MySQL: I did last look at it in detail a
> couple of years ago, but I remember having several problems with it,
> primarily because of features that were note implemented. MySQL is great as
> a temporary data store where queries essentially retreive row level data.
> AFAIR it was not so hot when doing grouping or other more complex queries.
how about a mix of straight joins and left joins on five or six tables -
several with many million rows?
> More importantly, it did not support transactions when I looked at it. From
> the sounds of it, MySQL now only has partial support for transactions.
> Another big issue was that it did not support outer joins.
dunno about outer joins, but it does support transactions with some
table types. mysql supports several backend table types.
> In my mind, I tend to think of MySQL as the open source alternative to
> Access databases, and Postgres as the alternative to SQL Server. I am
i think that's a poor comparison. to begin with access isn't really
client/server oriented, while that's the only way to use mysql.
> convinced that the enterprise class databases (Oracle, Sybase, DB2,
> Informix) will offer better performance, scalability and reliability under
> heavy load situations, but this may not be a real requirement in this case -
> especially if you only have 25 users. OTOH Postgres and MySQL have improved
> a lot recently, so may I need to re-evaluate my opinion of OSS databases.
wander into your local newsagent. if there's an alphyra credit card
terminal that sells o2/vodafone/etc top-up pins, you'll have a chance to
use mysql. the invoices the merchant receives every week (like several
(10+?) thousand others just like them) is generated from a mysql db
(via perl and troff).
i'm not quite certain what enterprise class is. does that sound like
it yet?
kevin
-- kevin at domain suberic.net that a believer is happier than a skeptic is no more to fork()'ed on 37058400 the point than the fact that a drunken man is happier meatspace place: home than a sober one. the happiness of credulity is a http://ie.suberic.net/~kevin cheap & dangerous quality -- g.b. shaw
This archive was generated by hypermail 2.1.6 : Thu 06 Feb 2003 - 13:18:52 GMT