Re: Which database?

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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073