Re: Which database?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Kaarel <kaarel(at)future(dot)ee>
Cc: Ewald Geschwinde <webmaster(at)geschwinde(dot)net>, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Which database?
Date: 2003-06-10 19:32:34
Message-ID: 200306101932.h5AJWYs18793@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

Kaarel wrote:
> > Depends on your needs
> > Mysql for smaller things.
>
> Does it mean MySQL is faster or more reliable with smaller amounts of data?

I think it is faster for simple, read-only (SELECT) queries on small data
sets.

Large data set, complex WHERE clause, non-SELECT, PostgreSQL is probably
faster --- plus we have more of the commercial database features.

Think MySQL as MSAccess, PostgreSQL as Oracle.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Network Administrator 2003-06-10 19:32:52 Re: [pgsql-advocacy] MySQL gets $19.5 MM
Previous Message Kaarel 2003-06-10 19:32:22 Re: Which database?