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(at)Yahoo(dot)com #

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