Re: Oracle vs Mysql

From: Daniel Hanks <hanksdc_at_about-inc.com>
Date: Tue, 20 Jan 2004 09:44:43 -0800
Message-ID: <F001.005DDA9D.20040120094443@fatcity.com>

On Wed, 14 Jan 2004, eric king wrote:

> I think he is talking about 100GB database. Can PostgreSQL and MySQL handle
> that size? We used MySQL in some of the web projects, but it just stores
> small set of operational data and later on those data are moved to Oracle as
> a permenant store. For small set of data, MySQL is quite good, but it lacks
> features such as foreign key constraints, triggers etc.

I seem to recall reports of Monty (the creator of MySQL) supporting terabyte size databases with earlier versions of MySQL. Not sure what types of storage systems were used to achieve that, though.

And to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only (iirc) if you use the 'Innodb' table type. Now whether or not a database allowing some tables to have FK support and others not is a good proposition you'll have to judge for yourself.

I still prefer Pg to MySQL.

Fwiw,

• Dan

  ---

  Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division

  ---

  -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: hanksdc_at_about-inc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 20 2004 - 11:44:43 CST