Re: Database Performance?

From: Devrim GUNDUZ <devrim(at)oper(dot)metu(dot)edu(dot)tr>
To: Robert Berger <rwb(at)vtiscan(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Database Performance?
Date: 2002-02-18 09:01:04
Message-ID: Pine.LNX.4.44.0202180912050.28416-100000@oper.metu.edu.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

"Performance improvements and replication".

This is MySQL. Not a database. I'd keep my data in a text file instead of
MySQL!

My friends, who use MySQL, say they would compile it without transaction
support, since MySQL users would not need it.

MySQL -> for the web...

That's all :)

Regards and best wishes,

Devrim

On Sun, 17 Feb 2002, 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
>

--

Devrim GUNDUZ

devrim(at)oper(dot)metu(dot)edu(dot)tr
devrim(dot)gunduz(at)linux(dot)org(dot)tr
devrimg(at)tr(dot)net

Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Innoxious 2002-02-18 09:17:27 Re: Report generation
Previous Message PG Explorer 2002-02-18 06:01:53 Re: Looking for a function