Re: Database Performance?

On Mon, 18 Feb 2002, Jan Wieck wrote:

> 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?

From a quick look at the docs the docs it appears the answers are no, no,
probably, I don't think so. Admittedly our support is a little weak
(a few bugs, the for update locking issues, and lack of match partial),
but theirs is still a little behind, although I'd guess that 4.1 will
probably start adding some of these things.