Re: Database Performance?

Robert Berger wrote:
> This argument is out of date. MySQL currently supports
> transactions, foreign
> keys, and outer joins. (4.1 will support subselects)
>
> As for fault tolerance, MySQL has built in support for replication.
>
> A couple years ago I converted a project from MySQL to PostgreSQL
> because
> of MySQL's lack of features. I am now in the process of converting
> back to
> MySQL because of the performance improvements and replication.

    Just  stating  "support  of  foreign  keys"  is IMHO a little
    fuzzy.  Are referential actions supported  (ON  UPDATE/DELETE
    CASCADE,  SET DEFAULT and SET NULL)? Can constraint checks be
    deferred?  Are multi-key references supported?  If  so,  what
    about match types?

    I  doubt that MySQL completely supports all of that. Wouldn't
    surprise me if it accepts the syntax though, while stating in
    the  FAQ  that  these  features are not really good, that you
    don't want them and if you write your applications correnctly
    don't need them anyway.

    So please, what exactly does MySQL support?


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com