Re: Database Performance?

Hi all,

A friend of mine who's into MySQL recently said told me that MySQL
doesn't *really* support transactions, it just looks like it does. He
then went on to say it doesn't really do ROLLBACK, or isolate the
transactions or something. Now, that's kind of FUD, but I'd rather it
not be. If someone out there knows if MySQL *really* supports
transactions (of the ACID variety) could they please speak up?

:-)

Regards and best wishes,

Justin Clift

Andrew Snow wrote:
>
> Doesn't PostgreSQL's better locking and query optimising mean that it
> performs better in multi-user situations?
>
> - Andrew
>
> On Sun, Feb 17, 2002 at 05:49:55PM -0500, 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.
> >
> >
> > >
> > > Be a little bit careful about benchmarks. Whether postgresql or
> > > mysql is
> > > faster depends on what you're doing. If all you want to do is the
> > > occasional
> > > insert and lots and lots of simple selects, mysql (or even grep)
> > > will beat
> > > postgres. If you want to do subselects, transactions, foreign
> > > keys, outer
> > > joins, fault tolerence or anything else that makes a database a
> > > database,
> > > mysql just can't do it.
> > >
> > > See if MySQL and PostgreSQL satisfy your business requirements and then
> > > decide which one you want.
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi